Forum Discussion
Wout
Helper I
Helper IPower BI | Access data source - doesn't show all the queries
Hi Forum, When i open my Access database i see 20 queries. And when i connect the Access file to Power BI i only see 16 queries.. Can anyone help me? Thanks.
This has happened to me tons of times. Turned out that i was using the NZ() function in my queries. If you are using that very common function, replace it with an IIF() function. That should do the trick.
EX:
IIF([fld] IS NULL , 0, [fld]) if you are testing a numeric value
or
IIF([fld] IS NULL , "", [fld]) if you are testing a string value
Lets assume your query which is invisble in Power BI is named Query1. Now create a new query in MS Access named Query2 which contains:
SELECT [Query1].* FROM Query1;
Save the query and in my case Query2 was visible in PowerBI.