MS Acess some of queries not showing in Power bi navigator

[Noorulwahab]

• I conneced Power BI Desktop successfully to an MS Access database. Everything went well. Now I added a couple of more queries in the Access database and those queries dont show in the Power BI Navigator. Can someone help? Suffering from last one week

Thanks in advance,

[rajendraongole1]

Hi @Noorulwahab - As per the above situation, make sure the new query are saved properly in Access and are not  temporary queries. They should appear in the Access navigation pane.

In power BI Desktop, go to the "Home" tab and click "Refresh."If the queries still don’t appear, try closing and reopening Power BI Desktop.

If none of the above steps work, try re-importing the database:

Go to "Home" > "Get Data" > "Access Database" and select your database again to refresh the list of available queries. 

still issue exist, you might consider creating the queries directly within Power BI using the Query Editor

Hope the above information helps.

[Noorulwahab]

Dear Sir, Thank you very for your message.

I have applied all of the steps you mention in your message, but still facing the issue and showing some of queries. let trying further to find some way for the subject issue.

Thanks agian!

Noor.

[Noorulwahab]

Dear Sir,

I have foud the issue, the query which I have used Nz function are not showing in power bi navigation durring connection. Please guide how to sole this, as Nz function aslo important to convert null value to zero.

further need help from your good self.

Thanks

Noor.