Forum Discussion

JonnoOon's avatar
JonnoOon
Frequent Visitor
9 years ago

Queries from Access missing in PowerBI

Hi All,   new BI user here.   I have a model which; 1) has a front-end excel model, where users can update data and assumptions 2) linked (live) into an access database, where a few queries are...
JonnoOon's avatar
JonnoOon
Frequent Visitor
9 years ago

Hi Anonymous

 

Thanks again for your support.

 

Does it work if the query selects columns from other queries which did have functions? 

I have tried making queries to pull from other queries but they are also not importing into BI. 

 

The issue is that all the work has already been done in Access (over 50 queries) and I was simply hoping to present it in BI rather than BI recalculating all of the outputs. 

 

2.49.4831.521 32-bit (August 2017) is my version - so looks like it is the latest one! 

 

Thanks so much Lydia

 

Jon

Anonymous's avatar
Anonymous
Not applicable
9 years ago

JonnoOon,

Would you mind sharing me your Access database so that I can test?

Regards,
Lydia

  • JonnoOon's avatar
    JonnoOon
    Frequent Visitor
    9 years ago

    Anonymous is there an email I can send to?

     

    Thanks


    Jon

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      JonnoOon,

      You can send me the Access database via Private Message.

      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        JonnoOon,

        I get error message when trying to open datasheet view of you query in Access. As your post, I am not able to view thw Access queries in Power BI Desktop. 

        However, when I try to create the following tables and queries in your Access database, I can view these queries in Power BI Desktop.



        Regards,
        Lydia