Getting data into Paginated report from PB dataset

[Markzolotoy]

I need to create a paginated report that should be getting data from a DB installed on-prem via the Gateway. for that I am creating a PB dataset first. The dataset las one query that is based on a stored proc execution. When I open New datatset in Report Builder I see something like this:

For dimension I am selecting sp_..... Then I need to add fields that I want to see in the query result. Can I add all the fields at once?

This dimension has been created with parameters. How can I provide these parameters? I really need some help here.

Thanks

[v-jingzhang]

Hi @Markzolotoy 

If you want to create a paginated report with data from a Power BI dataset, you could refer to below link. You can involve multiple columns in the same query.

Create a paginated report with a Power BI shared dataset | Microsoft Docs

And what do you mean by "This dimension has been created with parameters"?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.