Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Handling error in PowerBI.com

Hi guys,   I have an error which only occurs in PowerBI.com (so it is after publish)   Ther error it self is somewhat not informed much :   Couldn't load the data for this visual Couldn't ret...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, admin_xlsior 

You may refer to this post:

https://community.powerbi.com/t5/Service/Couldn-t-load-the-data-for-this-visual/td-p/423592

I think your dataset has RLS, right?
If this is a case, you need to assign role to user to apply RLS filter, otherwise they will got this can't load data error.

Row-level security (RLS) with Power BI

 

BTW, current RLS only works on read permission, so admin and dataset owner can see each records even if they not get RLS roles.

 

If not your case, please share your sample pbix file for us have a test. Do mask sensitive data before uploading

 

Best Regards,

Lin

 

  • admin_xlsior's avatar
    admin_xlsior
    Post Prodigy
    7 years ago

    Hi Lin,

     

    Thanks for your reply, I'll gladly like to share it, problem is, we're using Direct query to Azure database.

      • admin_xlsior's avatar
        admin_xlsior
        Post Prodigy
        7 years ago

        Hi,

         

        Actually we have other reports that using the same roles and setting, but it working just fine. 

        Beside Audit log, is there any other place that system will tell what is the error and from where it coming from ?

        Thanks,