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 quer...
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

HI candresbq 

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

Phil

  • 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