Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there, Wondering if anyone can help, or point me in the right direction.
I have a paginated report, using a PBI Dataset as it's dataset. Within the Report I have 4 parameters that filter the data down before the report eventually renders it.
Can someone show me how to pass, a or all, parameters through to the pbi dataset?
I gather a parameter is to be created in the PBIX... but it's how I map the paginated parameters to the PBIX ones... and of possible how they work.
All help greatly appreciated.
Solved! Go to Solution.
@mgtaylor3 , you can add power bi paginated report as visual in power bi report can that help ?
https://powerbi.microsoft.com/en-us/blog/power-bi-june-2021-feature-summary/#post-16112-_Toc74044952
or refer if this can help
https://p3adaptive.com/2020/06/power-bi-and-paginated-reports-better-together/
Hi @mgtaylor3,
I don't think you can directly pass your parameters to affect power bi datasets.
For the power bi dataset, you can try to parameter the query table connection with the query parameter then you can change on the power bi service side.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
For paginated reports, they didn't include these types of writeback features to affect power bi datasets.
Regards,
Xiaxoin Sheng
Hi There, Many Thanks for the past replies... I've gone through that method and while they work, my client, requires the report not to be within Powerbi. ah well.
Regards Mike.
Hi @mgtaylor3,
I don't think you can directly pass your parameters to affect power bi datasets.
For the power bi dataset, you can try to parameter the query table connection with the query parameter then you can change on the power bi service side.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
For paginated reports, they didn't include these types of writeback features to affect power bi datasets.
Regards,
Xiaxoin Sheng
@mgtaylor3 , you can add power bi paginated report as visual in power bi report can that help ?
https://powerbi.microsoft.com/en-us/blog/power-bi-june-2021-feature-summary/#post-16112-_Toc74044952
or refer if this can help
https://p3adaptive.com/2020/06/power-bi-and-paginated-reports-better-together/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |