The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
can we create a dynamic value and based on the selected value how can we get the records from the DB. Is it possible in power BI.
let say I have a date field , on the selection of the date field I should get the records from the DB and display in the report or we can say passing a parameter or variable to database and then pulling the data in Power BI.
NOTE: Date value has been used in multiple place within the query.
Any solution would be appriciated.
I didn't try that solution yet personally.. but i can add a link that will give you some idea how to acheive the solution.
Please check.
Thankyou @anupaminfo , but the date will be a database field which will be imported to powerbi on selection of the date i want the data to be fetched.
In the video you have shared the parameter date value has to pass. but i want the variable which should redirect to DB.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
14 | |
11 | |
3 | |
3 | |
2 |