Create a Paginated report using report builder which has a Direcr Query data source

[dosania]

Hi,

I'm tryign to create a Paginated Report to link use in my PowerBI dashboard, using an existing table visual that is in the report, for users to download and proint in it's entirity, using filter selections.

In PowerBI, I have used Performance Analyser to generate the DAX that creates the table.

When I paste this Query into PowerBI Report Builder, I get an error message telling me it is unable to handle the Direct Query/SQL part of the query, and is unable to create the report.

Are there any other options that would alloow me to create a Paginated Report in PowerBI using Direct Query, along with the DAX?

Many thanks

[v-kkf-msft]

Hi @dosania ,

Has your problem been solved? If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz

[amitchandak]

@dosania , there is a query builder, which allows you to select the columns you need from the give dataset for your paginated report, is that not helping?

[dosania]

I have additional calculated measures that I need to bring in to the report which aren't available to me in the columns available in query builder. Am I able to create these measures directly in Report Builder?

[v-kkf-msft]

Hi @dosania ,

I was able to successfully use DAX to return tables like this.

Maybe you can refer to these documents to see if it works.

Create a paginated report based on a Power BI shared dataset 

Introduction to DAX for paginated reports 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.