Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
@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