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

 

I've tried replicating the exact query you made. 

 

This appears in BI navigator. 

 

Do you happen to know what functions specifically are not supported by BI? 


I've also tried creating queries that simply select columns from queries which were not appearing (e.g. in the access database BI_LineOEE simply selects columns from another query) - and these also are not appearing in BI. 

 

Thanks,

 

Jon 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

JonnoOon,

There is no official article and blog stating the supported Access functions in Power BI. But you can load your table to Power BI Desktop, and re-create these queries you need.

Regards,
Lydia