Forum Discussion
Dynamically Change the Database name in the Powerbi desktop
Hi All, I am trying to change the database name dynamically in the powerbi from the powerbi rest api call. I created parameters for server and database name and use that in the query . I am ...
Thanks for the reply. Can you elaborate on that swap out the database name in the custom sql query?
let Source = Sql.Database(server, database1, [Query="Select * from [database2].[schema].[table]"])