ANLC table not showing any data in Power BI Desktop

[GS10]

Hi Experts,

While loading the SAP table ANLC in Power BI desktop I'm able to see the structure of the table only.Attached the screenshot for the reference.

As the above shown screenshot only the structure of the table is showing but no data's are there.

Regards,

GS

[AmiraBedh]

Go to "File" > "Options and settings" > "Options" > "Privacy" and review your data privacy settings. Sometimes, privacy levels can cause issues with data visibility.

[GS10]

Hi @AmiraBedh ,

This is my privacy settings.

[selimovd]

Hey @GS10 ,

did you refresh the data model?

How sure are you that there is data in the table and you have access? How does the preview in Power Query look like?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn

[GS10]

Hi @selimovd ,

Even I refreshed the dataset it's showing the same as the above and as well in Power Query. 

Note: I'm facing this issue only for this ANLC table

[selimovd]

Hey @GS10 ,

then it seems to me that you either don't have access to the table or that the table is empty.

Do you have any other tool to check your access on a database level?

Best regards

Denis

[GS10]

@selimovd ,

I checked with SAP team, they are showing the data in the db level but when I pull the table in Power BI desktop I can't see any data.

Only this table in production server is showing this issue.

[selimovd]

@GS10  then it seems like you don't have access. Can you check with another tool if you have access to see the data?

If in Power BI you don't see data, for me that's a sign that the RLS is filtering out all of the rows. Please check and maybe get in contact with the SAP team