Solved: Change pbix data source programmatically - Page 2

JorgeDiego · ‎02-09-2017

Hi everyone,

I want to know wheter is it possible to change the data source from a pbix file programmatically.

I want to use the same report for different customer that use different data bases, with the same schema.

Currently, I develop a report using an internal data base and then I change this report data source for every customer and I upload the pbix file to them power bi account. So, what I want to do is to make this process programmatically to do it faster and avoid possible errors.

Thanks in advance.

v-shex-msft · ‎02-19-2017

Hi @JorgeDiego,

As you said, power bi not support to direct modified the datasource without open the pbix file, perhaps you can submit your requirement to ideas.

In addition, you can try to store your connection string to a config file, then write a custom function to analysis this file. After these steps, you can change the datasource without open the pbix file.(After you modified the config file, you should refresh it at pbix report to get the newest data)

Sample:

let
xmlTable = Xml.Tables(File.Contents("C:\Users\xxxxx\Desktop\test.xml")),
server=xmlTable[Server]{0},
database=xmlTable[Database]{0},
Source= Sql.Database(server,database)
in
Source

Xml:

<config>
<Server>"abc"</Server>
<Database>"edd"</Database>
</config>

Screenshots:

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎02-09-2017

Hi @JorgeDiego,

You can take a look at below link which about use parameterized power query function to load the data source:

Deep Dive into Query Parameters and Power BI Templates

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Change pbix data source programmatically

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly