Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
KDESU
New Member

Embed report for push datasets is not working

Hi, 

 

We have created a push dataset as documented by power BI and also pushed the data regularly and can see the paginated report from power BI without any issues. But when the paginated report is embedded in our app (created in angular) we are getting the error like I cannot connect to the "Analysis services" and it's failing to load the report. We can embed the normal report without any issues but not the paginated report. 

 

We also tried embedding the paginated report with the normal dataset and that's also working fine. Embed report with push dataset is not working. 

 

Any help on this will be much appreciated 

 

Thank you in advance 

 

2 REPLIES 2
asarraf21
Frequent Visitor

I am having the same exact issue. I have created a push dataset and used power bi service to create a Paginated Report. It shows up fine when I access it in the workspace but throws an error when embedding. 
This is part of the error. I am using a service principal that has Admin access to the workspace and everything is under the same workspace. 

    "title": "An unexpected error occurred",
    "message": "Connection open intermittent error while reading in Analysis Services, needs retry.",
    "rootActivityId": "76a1b6b8-80bc-e986-28ba-02f769782b0e",

 

UPDATE: 

When I authenticate with a master user and use Aad as tokenType, the embedded report loads up properly. This already is in contract with the first bullet point, i.e. You must use a service principal. Master user isn't supported.

 

Anonymous
Not applicable

Hi @KDESU ,

The following link is the supported data sources for Paginated reports, and please check whether it hit any following limitations.

Supported data sources for Power BI paginated reports

yingyinr_0-1649307382259.png

Best Regards

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.