topic Re: Power Bi Embed: Can't load data for this visual in Developer

Power Bi Embed: Can't load data for this visual

FabioIkoMotta — Tue, 06 Sep 2016 14:36:34 GMT

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?

Re: Power Bi Embed: Can't load data for this visual

ankitpatira — Tue, 06 Sep 2016 23:41:38 GMT

@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.

Re: Power Bi Embed: Can't load data for this visual

Eric_Zhang — Wed, 07 Sep 2016 09:01:47 GMT

@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?

Re: Power Bi Embed: Can't load data for this visual

FabioIkoMotta — Thu, 08 Sep 2016 14:34:52 GMT

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/

Re: Power Bi Embed: Can't load data for this visual

Eric_Zhang — Fri, 09 Sep 2016 02:03:53 GMT

@FabioIkoMotta

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?

Re: Power Bi Embed: Can't load data for this visual

FabioIkoMotta — Mon, 19 Sep 2016 15:10:12 GMT

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.

Re: Power Bi Embed: Can't load data for this visual

NehaS — Wed, 05 Apr 2017 00:37:29 GMT

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

Re: Power Bi Embed: Can't load data for this visual

NehaS — Wed, 05 Apr 2017 00:40:13 GMT

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

Re: Power Bi Embed: Can't load data for this visual

sampathkumar — Thu, 13 Jul 2017 05:45:33 GMT

thank you so much bro, it works for me

Can't load data for this visual

jd_18 — Fri, 11 May 2018 17:26:22 GMT

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.