Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Haripriya_9
Frequent Visitor

Dynamic Parameters

‎04-13-2023 02:30 AM

HI Team,

I have a requirement  on dynamic parameters cocept . I have imported a sql query in which User Id column is a parameter , Whoever logg's in  the power Bi report in desktop using corresponding email id, Corresponding User Id should set dynamically in the  imported sql query. Please find below screenshots for reference.  

For example, userid is declared as 1 but, it should be replaced with corresponding User id (It can be either 3011,3008..etc)which should be fetched from database as shown below 

Haripriya_9_0-1681377754834.png

Haripriya_9_1-1681378076682.png

 

How we can achevie this ??


Thanks in advance !!

Message 1 of 1
205 Views
0
0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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

View All