Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lars_Denmark
Frequent Visitor

Paginated report with parameters and using PBI dataset from the service

I am in the process of making a paginated report in PBI Report Builder, which uses a dataset from a PBI dataset from the service. In this connection, I have used the Performance Analyzer to copy the DAX query from a PBI visual and paste the code in the query designer in report builder. But to be able to insert the code in the Query Designer, I must first go out of design mode. After inserting the DAX code, it is not possible for me to add parameters, as I can not switch to design mode again without deleting the DAX code.

 

Lars_Denmark_0-1603451730574.png

 

Among other things, I have tried to insert a parameter as shown in Chris Finlans' video: 

https://www.youtube.com/watch?v=SuGcB_tm6VI

 

Is there anyone here in the community who has a best practice solution for this, or a reference to an article where the solution is described.

1 REPLY 1
Daviejoe
Memorable Member
Memorable Member

I'd love to help you on this one but your query level is a bit beyond my level at the moment.

 

I'm having my own Paginated Report query issues today haha.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors