Empty Data Table

[candresbq]

Hello.

When I connect the PBi with an MS Access DB and click on the table it tells me that the table is empty, but in MS Access it does have data. I've noticed that in The Access it's like a query.

He sent screenshots in case anyone could help me.

The latter is to show you that in MS Access if you have data.

Thanks a lot.

[PhilipTreacy]

HI @candresbq 

Have you written any custom SQL in the query that may be resulting in no data?

Phil

[candresbq]

Thank you for your response.

The table appears empty from source. Just by making the appointment. I do not insert any code.

Thank you.

[Anonymous]

Hi @candresbq ,

Is it because the table contains some confidential data and requires special permission to view it? Did you load the data of this table in Power BI Desktop before successfully?

Best Regards

[Anonymous]

Hi @candresbq ,

Please try to install the Access Database Engine with latest version, you can get it from this link.  What's the version of your Power BI Desktop? How did you connect to Access? Whether the other tables from Access can load the data into Power BI successfully? 

Best Regards

[candresbq]

Hello, the Access Database Engine is installed. I can see the data from other queries seamlessly, it is only in this query where it appears empty to me.

I have the latest version of PBI.

Thank you so much for your help.