Forum Discussion

AjithPrasath's avatar
AjithPrasath
Icon for Resolver II rankResolver II
2 years ago

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 ...
General Comment
Need Help
Tutorial Requests
AjithPrasath's avatar
AjithPrasath
Icon for Resolver II rankResolver II
2 years ago

Thanks for the reply. Can you elaborate on that swap out the database name in the custom sql query?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

let Source = Sql.Database(server, database1, [Query="Select * from [database2].[schema].[table]"])