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,

I click the following button. I suspect that some expressions that you use in  your queries are not supported in Power BI Desktop.


What is the result when you create the sample query as I do?

Regards,
Lydia

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