cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Coan7
Post Patron
Post Patron

Dynamic azure sql database as parameter

Hi, 

 

We have several databases consist of tables with the same schemas on a server. I have read that it's possible to switch between databases as sources for a report using parameters. However when I tried to use the parameter in the source --> applied step (power query) it does not catch the new database. 
In the advance editor, I can see it is adding the parameter behind let Source = Sql.Databases("SERVER"),database (parameter)....

Could this be correct??!!

How to correctly dynamically change database????

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.