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
Rich_P
Helper II
Helper IIThis 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
