Based on your description, I created a Analytics view including those fields you mentioned and they were also the columns I could fetch from that view into Power BI. Here are the steps for your reference.

You may check if the issue in your 2nd problem is gone, once you retrieve the expected data.