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
saswati0709
Frequent Visitor

Passing Parameter/Variable To Database and fetching the records to Power BI

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.

2 REPLIES 2
anupaminfo
Frequent Visitor

@saswati0709 

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.

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

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.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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