Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
I follow exactly the sample (.sln) provide by Microsoft .
I create workspace, uploaded pbix file, update database connection string and display it in a MVC web.
Is works fine when the file I upload is new.
If I upload a file that I was previously published in Power Bi Service, it fails and show a warning "can't load data for this visual".
Both reports uses the same connection, database and tables.
Must I recreate the files or there is any work around?
Solved! Go to Solution.
I find out the problem.
I published a pbix in Azure that was using RLS parameter.
Because this it works in Power BI Service and didn't in Azure.
Azure doesn't allows RLS.
Tks.
I find out the problem.
I published a pbix in Azure that was using RLS parameter.
Because this it works in Power BI Service and didn't in Azure.
Azure doesn't allows RLS.
Tks.
thank you so much bro, it works for me
I created an excel file with three variables (year, month, cost) and then imported in to Power BI (desktop). I can see the relatioships and data, but when I tried to create the report (with a simple chart) and the error showed up: Can't load data for this visual
Not sure why.
hey FabioIkoMotta ,
Thanks you very much. You save my day. I was stuck in this issue for more than a day. I tried updated connection string after importing my pbix (as suggested in other post for direct query) but nothing happened. Then i came across your post and found out that i also have Roles created in my pbix files. Although i was not using these roles but just have created it but still i was getting forbidden error(401).
Then i deleted all the roles i have created in my pbix file then i imported again, updated connection string and it works.
Thanks again
hey FabioIkoMotta ,
Thanks you very much. You save my day. I was stuck in this issue for more than a day. I tried updated connection string after importing my pbix (as suggested in other post for direct query) but nothing happened. Then i came across your post and found out that i also have Roles created in my pbix files. Although i was not using these roles but just have created it but still i was getting forbidden error(401).
Then i deleted all the roles i have created in my pbix file then i imported again, updated connection string and it works.
Thanks again
@FabioIkoMotta wrote:
I follow exactly the sample (.sln) provide by Microsoft .
I create workspace, uploaded pbix file, update database connection string and display it in a MVC web.
Is works fine when the file I upload is new.
If I upload a file that I was previously published in Power Bi Service, it fails and show a warning "can't load data for this visual".
Both reports uses the same connection, database and tables.
Must I recreate the files or there is any work around?
That sounds really weird. I don't reproduce that. I can import an pbix that already published to Power BI Service to workspace and embed the report without problem.
Can you be more specific on your pbix, is that an DirectQuery to Azure database? If yes, have you configured the credential correctly? Regarding the warning "can't load data for this visual", what is the detailed message?
Tks for your answer.
Follow detailed message:
Código de status Http401
ID da atividade27fa4f5a-858f-4c2a-a7bc-c934ef3e63b5
ID de correlação47a9c5f8-571d-3e5c-a01d-ef727cefe773
Solicitar ID84a39c4d-6420-1a22-9895-e9b94704e4af
HoraThu Sep 08 2016 11:32:26 GMT-0300 (Hora oficial do Brasil)
Versão13.0.1605.432
Cluster URIhttps://wabi-brazil-south-redirect.analysis.windows.net/
HTTP Error 401 means Unauthorized, can you be more specific on what is the database in your case, how the pbix connects to the database, direct query or import? How did you embed the report?
@FabioIkoMotta Never really tried this but my guess is APIs that does upload has limitation on overriding existing pbix files that are already uploaded. If via power bi desktop you do that your report / dataset in service gets overwritten maybe APIs don't have that capability yet. I would suggest you try renaming the file and then publish.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.