Forum Discussion

candresbq's avatar
candresbq
Frequent Visitor
5 years ago

Empty Data Table

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.

candresbq_1-1607611930474.png

candresbq_0-1607611846294.png

candresbq_2-1607612021969.png

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

candresbq_3-1607612052047.png

Thanks a lot.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      candresbq
      Frequent Visitor
      5 years ago

      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.

    • candresbq's avatar
      candresbq
      Frequent Visitor
      5 years ago

      Thank you for your response.

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

      candresbq_0-1608289101089.png

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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