Crosstab Queries

[connorjmusic]

Hi folks, new here and VERY new to Power BI

Apologies if this is out there - I searched around but couldn't quite find what I was looking for.

I have an accdb with crosstab queries, and I want to import those queries into Power BI. However, when I grab my data from Access, the tables show up, but the queries do not. How do I rectify this?

Thanks in advance!

[v-yuezhe-msft · Accepted solution]

@connorjmusic,

It is not possible to  import Crosstab queries from Access database to Power BI. I would recommend you import underlying tables into Power BI Desktop, then shape and transform data to get expected output.

Regards,
Lydia