power bi embed - couldn't load the data for this visual

[nitinkmishra]

Hi team,

we have a report that works well in Power BI Desktop and Power BI service, however, when we try to embed it, we get the following error -

Couldn't load the data for this visual

Activity ID: 5bb160d2-ca6d-486c-8f00-5f4c5e9f846c
Request ID: 05f08846-fe2f-4fda-ba15-1d29c3010257
Correlation ID: a9a35b43-4545-0959-04ff-6750a06f3126
Time: Mon Dec 04 2023 04:42:58 GMT-0600 (Central Standard Time)
Service version: 13.0.22105.76
Client version: 2311.3.16917-train
Cluster URI: https://WABI-US-EAST-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 5bb160d2-ca6d-486c-8f00-5f4c5e9f846c
Request ID: 05f08846-fe2f-4fda-ba15-1d29c3010257
Time: Mon Dec 04 2023 04:42:58 GMT-0600 (Central Standard Time)
Service version: 13.0.22105.76
Client version: 2311.3.16917-train
Cluster URI: https://WABI-US-EAST-B-PRIMARY-redirect.analysis.windows.net

The same report works well in our app after embedding if direct query is not used

[Anonymous]

HI @nitinkmishra,

Are you worked with publish to web feature to embed your report? As the document mentions, current it existed a limit when you use this feature with report include direct query model data source.

For detail information, you can check the official document limitations parts:

Publish to web from Power BI - Power BI | Microsoft Learn

If the above not help, can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[nitinkmishra]

Hi,

No, I am not using that, I am embeding the report using access and embed token, for your company model. also,The javascript call is returning 403. Please be advised that its try to connect to Azure database . The issue started when one of tables were changed to direct query from import.

The power bi report is using gateway to connect.

[Anonymous]

Hi @nitinkmishra,

Did you mean to update the datasource connection mode without re-configug and embed the new version report?

If that is the case, the report data source and credential should match with the configured settings.

These internal credentials and configurations not match with the old version so embeded report not able to load data from report datasource.

Regards,

Xiaoxin Sheng

[nitinkmishra]

what do you mean by - update the datasource connection mode without re-configug ? can you point me to some documentation? 

I never passed any credential or database connection mode in the previous version too,The one with import,

the app user principle is added to the allowed user. 

[Anonymous]

HI @nitinkmishra,

They mean you are 'change on the underlying report dataset connection modes and not apply any update on the embedded report'.
AFAIK, the rest API to generated embed token are bind with the dataset and report.
When you update on the data source connection mode, the old version connection string and credentials of embed report should different form the report and they will cause the conflict between two version reports.(the prerequisite of power bi service refresh required the configured data source credentials is same to the published power bi report)
Regards,

Xiaoxin Sheng

[nitinkmishra]

How do I update the connection in the embed report? In other words, How do I apply this update on the embed report?

Also please be advised that we now only have one report with direct query.

[nitinkmishra]

I wanted to specify that report headers load but not data