Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
@PARIS2020 , refer
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
HI @PARIS2020
Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
I have 2 tables :
- a header table Ticket(IdTicket, summarize, Creation-Date, IdStatus)
- detailed table Status (IdStatus, oldStatus, New status, IdTicket)
I need to find records on the Stauts table based on the IdTicket selected.
The IdTicket, appears in a report filter, and when I click on the IdTicket that interests me to select it. Once selected, this filter acts on the Status table to display only the records corresponding to the IdTicket selected.
My problem is that this operation requires retrieving more than 2 million lines, and it does not work well. I would like to be able to click on my IdTicket filter, and the selected value will be passed as parameter of a query that only fetch the values that interest me.
did you manage to find a solution to this ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |