Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am creating a dataset for a paginated report. Dataset has one query that uses parameters. When I get that dataset into Report Builder and create a report dataset how can I provide these parameters?
Thanks
Solved! Go to Solution.
@Markzolotoy
I am thinking if you move the report from ssrs to pbirs, and "edit in Power bi desktop". You can have your parameter in power bi desktop for rs, then publish this pbix to power bi report service.
Solved: Move SSRS reports to existing PBIRS - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Markzolotoy
I am thinking if you move the report from ssrs to pbirs, and "edit in Power bi desktop". You can have your parameter in power bi desktop for rs, then publish this pbix to power bi report service.
Solved: Move SSRS reports to existing PBIRS - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Also when you say refresh the dataset can that be done automatically when a user is about to run the report? If not, what about when a scheduled report export is about to run?
Here is what I am trying to achieve. I am converting a SSRS report into a paginated report that will be run on the Service. The data is stored on-prem server and will be accessed via the Gateway. In order to get this data into a paginated report I am creating a PB dataset. The dataset is based on an SQL stored proc. Execution of which takes two parameters. What would the right approach be?
@Markzolotoy you cannot provide the parameter to the Power BI dataset from the Power BI report builder. You have to first refresh the dataset in Power BI Service by entering the value of the parameter. Not sure what you are trying to achieve here, not sure if this is the right approach.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |