Forum Discussion

connorjmusic's avatar
connorjmusic
Regular Visitor
8 years ago
Solved

Crosstab Queries

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!

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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