Forum Discussion
Creating a generic data source for a PQ query
Hi, for a customer I need to manage the data loading from a SQL Server table in the dev environment and the data loading from the corresponding Oracle table in the prod environment. In other terms, ...
Please see this article. You should be able to adapt this approach.
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD
Pat
There are several ways you could do this. One simple one would be like this. Just change the SourceToggle value away from 1 to change to prod.
let
SourceToggle = 1,
Source = if SourceToggle = 1 then Sql.Database( ) else Oracle.Database( ),
rest of query
Pat
Hi,
I've SourceToggle as a PQ parameter, but after publishing the pbix on Power BI service I cannot edit this parameter.
How could I solve this issue? Thanks