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...
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

      • JonnoOon's avatar
        JonnoOon
        Frequent Visitor
        9 years ago

        Hi Lydia,

         

        What exactly do you mean by "Datasheet view of queries in Access" - please excuse me, I'm fairly new to both Access and BI. 

         

        Do you know the reason why / any solutions for why the Access queries are not available in PowerBI Desktop? 

         

        Thanks,


        Jon