Paginated report for CDS data

[krombipils]

Hi,

I'm trying to create a paginated report for data in the Common Data Service. While it is possible to connect to this kind of data from Power BI Desktop, it is not possible from Power BI Report Builder.

Will this be supported in the (near) future? Are there any workarounds?

I'm used to develop quite complex master-details reports containing subreports (and page header/footer) with DevExpress XtraReports and I wonder whether it is possible to get similar results with Power BI reports...

Thank you!

[mwegener · Accepted solution]

Hi @krombipils ,

take a look at this.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Paginated-Reports-on-CDS-data/td-p/310075

... or use a Power BI dataset ...

https://docs.microsoft.com/en-us/power-bi/report-builder-shared-datasets

[krombipils]

Thank you @mwegener,

the report designer in PowerApps is very limited, but I managed to create quite a nice report using the Report Authoring Extensions and FetchXML. I think the setup isn't very comfortable, but it's okay for now.

I will also take a look at the Power BI datasets...