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,

In my scenario, when I create a simple query that select some columns of a table in Access, the query appears in Power BI Desktop. Do you use the latest version of Power BI Dekstop(2.49.4831.521)?

And in your scenario, you can apply criteria(sum,mulityply, divide) in Power BI Desktop instead of Access.

Regards,
Lydia

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