cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adrianvp
New Member

Embedding paginate reports with dynamic Dataset

Hi All,

 

Hopefully a simple one. We currently embed reports in Power BI into our own application (SaaS solution). We can successfully embed reports with dynamic datasets and RLS. Everything works as expected.

 

However, we are testing embedding paginated reports which work fine if the dataset provided to the report is that same as the one used to create the report. If we try change the dataset for the paginated report we get the error : Dataset id xxx is requried by report yyy but was not found in generate token request.

 

Is it possible to use dynamic datasets with paginated reports?

 

Thanks

1 ACCEPTED SOLUTION
AmosHersch
Microsoft
Microsoft

 

Hi @adrianvp ,

 

Unfortunately dynamic binding of a paginated report to a dataset is not a supported feature.

This is  mainly because a dataset is a data source for a paginated report, and there can be more than one dataset for the same paginated report, in oppose to a Power BI report which only has one dataset (directly connected).

View solution in original post

2 REPLIES 2
adrianvp
New Member

Thanks Amos, really appreciate the response. We can stop banging our heads against the wall now 🙂

AmosHersch
Microsoft
Microsoft

 

Hi @adrianvp ,

 

Unfortunately dynamic binding of a paginated report to a dataset is not a supported feature.

This is  mainly because a dataset is a data source for a paginated report, and there can be more than one dataset for the same paginated report, in oppose to a Power BI report which only has one dataset (directly connected).

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.