Forum Discussion

JorgeDiego's avatar
JorgeDiego
Advocate I
9 years ago
Solved

Change pbix data source programmatically

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

kkalyanthaya's avatar
kkalyanthaya
Microsoft Employee
8 years ago

Anonymous,

 

Can this method be used as a way to share templates / content packs to connect to different sources ?

The history behind this question is here.

modelmike's avatar
modelmike
Frequent Visitor
8 years ago

I was able to solve this problem using a paremeter in Power Query. The parameter is set to the users dropbox "home" local folder. Then, when I share the PBT file it prompts the user to enter their specific filepath before creating their user-specific pbix. This isn't quite automagical but it does the job.