Forum Discussion
Getting data into Paginated report from PB dataset
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
1 Reply
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.
