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 run to calculate final costs etc. 

3) queries are imported from access into PowerBI. 

 

Am noticing that quite a few of my queries in access are missing in BI.

 

I've done some preliminary searches, and they are not union queries ..

can't seem to figure out why it would be missing!

 

Any help you can offer would be much appreciated

 

Jon 

 

 

 

14 Replies

  • JonnoOon's avatar
    JonnoOon
    Frequent Visitor
    9 years ago

    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 run to calculate final costs etc. 

    3) queries are imported from access into PowerBI. 

     

    Am noticing that quite a few of my queries in access are missing in BI.

     

    I've done some preliminary searches, and they are not union queries ..

    can't seem to figure out why it would be missing!

     

    Any help you can offer would be much appreciated

     

    Jon 

     

     

     

    • mohamedafi's avatar
      mohamedafi
      New Member
      2 years ago

      I have the same problem, please let me know if you found the solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    JonnoOon,

    Do you have any functions in the Access queries? Access queries will not appear in Power BI Desktop if you have functions, please remove functions from Access queries.

    Regards,
    Lydia

    • JonnoOon's avatar
      JonnoOon
      Frequent Visitor
      8 years ago

      Hi Lydia Anonymous,

       

      thanks so much;

       

      can i clarify; even a basic sum function wouldn't be able to flow from access into BI?
      My access database has no other functions than sums, or multiplying/dividing data in a query. 

       

      Also, to test your solution I've tried making additional queries which simply select data from other queries which used sum functions etc.  These are still not appearing in BI. 

       

      For example; 

      qry_OEE_ByLine (image 1 on left) has a function at the end to calculate a metric by adding / dividing some values. this was not appearing in BI navigator.

      I then made qry_lineOEEImport (image 2 on Right) then simply selects the outputs of that into a new query.

      This still does not appear in BI navigator. 

       

       

       

       

      Thanks very much

      Jon 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 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