Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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