Forum Discussion
Different data sources with the same visualisation in one page
If i read you correctly, you want an easy way to point to a different environment but with identical schema, such as repoint a report from dev to UAT to Production data sources.
There is no dropdown, but the dropdown under the "Edit Queries" button allows editing of data sources. In here you can change various parameters, depending on what options the source allows you to alter.its also possible to use a parameter to change connection, which may help provide what you require, have a look at this article:
https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-connection/ba-p/392016
Post PatronIf i read you correctly, you want an easy way to point to a different environment but with identical schema, such as repoint a report from dev to UAT to Production data sources.
There is no dropdown, but the dropdown under the "Edit Queries" button allows editing of data sources. In here you can change various parameters, depending on what options the source allows you to alter.
its also possible to use a parameter to change connection, which may help provide what you require, have a look at this article:
https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-connection/ba-p/392016
Hi wilson_smyth Chaning connection server name via parameter is achived using parameter but Since my Schema name is not identical in UAT and Live I want to change Schema name too at once. Is this doable?
Please see my original post here: https://community.powerbi.com/t5/Desktop/Schema-change-to-multiple-queries-SAP-hana-and-Direct-query/m-p/749956#M361491
Note: I am using SAP HANA with Direct query.
Thanks,
Kul
- wilson_smyth
Anonymous
The report depends on the underlying schema. If its looking for a TableA.ColumnA, but this doesnt exist after you point to a new environment, the report will break.
There are probably ways to work around this in some cases, but its not recommended. reports really need a stable schema.
if the only thing that changes are columns or tables that you are not using, then you should have no problems.Hi wilson_smyth in my case Schema name and server name are different but the columns are identical in the table. Only thing change is data (rows). One server+schema having less data but another having more data.
on my UAT environment i am using a PowerBifile1 with Server1+schema1. But,
on my Prodcution environment i am using same PowerBifile1 with server2+schema2.
What I am able to do is change the Server1/2 name using parameters. But I am also looking for solution that change schema name as well some how.
I use function to get data not direct tables. please see example below how my query looks like:
SELECT * FROM "SCHEMA1"."FN_Name"();
Note: Currently I open my powerbi file and change the schema manuly that is lot of effort if i have suppose 100 tables.
- wilson_smyth
in that case, when you mean database schema used to organize objects and for security, yes, that can be parameterized, i.e. create a parameter and reference it in your power query.
there are some details in this post on the community.