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