Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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, I've two different data sources between two environments.
I thought to create an empty query having as a first row something like Source = Connection_string_param, where this parameters contains the database server, the database name, likely also the access credentials and perhaps a table name, e.g.:
- for the SQL Server source, Connection_string_param = Sql.Database("database_server", "database_name"),
- for the Oracle source, Connection_string_param = Oracle.Database("database_name").
Is it possible to create a such parametric query? Any helps to me, please? Is it possible switching somehow from a data source to the another one?
Many thanks
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
Hi Pat,
thanks for your reply.
I've tried your suggest in pbi desktop and it functions rightly!
On power bi service after the publishing?
I'm interesting to know other ways to solve this issue. Is there any articles about this subject?
User | Count |
---|---|
8 | |
6 | |
6 | |
5 | |
5 |
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |