Forum Discussion
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
14 Replies
- vanessafvg
Community Champion
Wout is there a difference in the type of queries these missing queries are?
WoutThanks for your reply. I cant find any differences.
v-jiascu-msftMicrosoft Employee
Hi Wout
It’s a little strange. Let’s check it step by step. It seems that “Forms” and “Reports” can’t be imported. Could you check on your scenario please?
Best Regards!
Dale
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.
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.
