Power BI Embedded sporadically unable to load data for some visuals

[MHedley]

Two Visuals in our report are getting the error "Couldn't load the data for this visual" when viewed embedded. One seems to happen sporadically, while the other consitently fails. Other visuals in the report are functioning fine, and the two in question work fine when the report is opened in Power BI Desktop.

Details (Sporadic failure):

Activity ID89680739-16cd-415b-8434-d97373323a37

Request IDedb65c43-cca9-5088-954d-e06e7e27c1fd

Correlation IDea5d901c-ca5d-42b8-f320-8b8a410b7134

TimeThu Jun 01 2017 15:27:23 GMT-0400 (Eastern Daylight Time)

Version13.0.1700.2352

Cluster URIhttps://WABI-US-EAST2-redirect.analysis.windows.net

Details (Consitent failure):

Activity ID8ba6cfe4-7e80-70d7-615b-bd061e7dcbdc

Request ID01a96a60-cfe5-935f-1559-6724e1140543

Correlation ID737f31e9-54b5-d957-45be-01dcbe2874a9

TimeThu Jun 01 2017 15:29:37 GMT-0400 (Eastern Daylight Time)

Version13.0.1700.2352

Cluster URIhttps://WABI-US-EAST2-redirect.analysis.windows.net

[v-huizhn-msft]

Hi @MHedley,

For you issue, you can create a support ticket(highlighted in yellow background) here. 



Thanks,
Angelia

[MHedley]

Hi Angelia,

I had tried to do just that before posting but when I click that link it asks me to sign in, when I click the sign in link I get routed to Power BI, and when I return to the support page it again asks me to sign in, causing a bit of an inescapable loop.

[v-huizhn-msft]

Hi @MHedley,

After you click the "Create Support Ticket", you will get the following screenshot.



Then please search if there is similar issue, if there is not, you can click "Continue to support ticket"


Best Regards,
Angelia

[MHedley · Accepted solution]

WHen I click Create Support Ticket I do not get those options. I get prompted to log in despite already having done so.

I have managed to resolve the issue I was having by reworking most of the query transformation into a SQL view and not using the features in Power BI.

[insoluzioni]

So we could assume that the best way to work with Embedded is to hold on to good ol' SQL views...

They could change the name to Power Embedded, because the "BI" part doesn't work.