cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors