Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.