The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All, I have develoved dashboard based on the PowerBi dataset, I am getting the below error in the publisher. Please help me.
Solved! Go to Solution.
Hi @titanic123 ,
What data source is your report connected to? Does the report apply any RLS? And can it display properly in Power BI Desktop? There are many reasons that may cause this error, please check the following threads that have similar error messages to yours. Hope they can help you to solve the problem.
Couldn't load the data for this visual
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.
Service: "Couldn't load the data for this visual", Desktop: all fine
The issue was the date in this function. replacing 31.01. by 31/01 solved the issue.
Couldn't load the data for this visual
The problem was that I had finished my SQL query with semicolon;
When I removed the semicolon from the SQL query in advanced editor, the issue was resolved
Couldn't load data for this visual
You added build permissions to your shared dataset. Did you add build permissions to the dataset your dataset is sourced from? This typically explains this behavior for us, we build a Report B from Dataset A we must grant permissions at both sources.
could not load data for the visual
Refer to this post here. Your problem might be related. As suggested by the user trying changing data type of column in data source. If you think it is not related then perhaps open a support ticket with MS support.
Best Regards
Hi @titanic123 ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
Hi @titanic123 ,
What data source is your report connected to? Does the report apply any RLS? And can it display properly in Power BI Desktop? There are many reasons that may cause this error, please check the following threads that have similar error messages to yours. Hope they can help you to solve the problem.
Couldn't load the data for this visual
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.
Service: "Couldn't load the data for this visual", Desktop: all fine
The issue was the date in this function. replacing 31.01. by 31/01 solved the issue.
Couldn't load the data for this visual
The problem was that I had finished my SQL query with semicolon;
When I removed the semicolon from the SQL query in advanced editor, the issue was resolved
Couldn't load data for this visual
You added build permissions to your shared dataset. Did you add build permissions to the dataset your dataset is sourced from? This typically explains this behavior for us, we build a Report B from Dataset A we must grant permissions at both sources.
could not load data for the visual
Refer to this post here. Your problem might be related. As suggested by the user trying changing data type of column in data source. If you think it is not related then perhaps open a support ticket with MS support.
Best Regards
Hi, I am having the same issue. In my case the data source for my dataset A (see picture) are coming from two API streaming dataset C and D (see picture). If I share the dasboard via link they are only able to see the dashboard but not the contend inside the visuals, geeting the 'Couldn't load the data for this visual '. They are only able to see the data if I make them admin of the workspace. FYI other users also have Pro licences. Any ideas
Hi there, did you get this working in the end? We are experiencing similar issues and can't figure it out, it is happening to some users but not others. Checked all the usual things, i.e. permissions, RLS, etc. Can't find a solution though. Fingers crossed you solved it!
Thanks, Richard
Hi, in my case it looks like I also have to gave permision for the API streaming datasets. Read permisions seem to work fine
Thanks for coming back so quickly, much appreciated, I will take another look at permissions and try that.
Kind regards, Richard
Have you tried again? Is it reproducible?