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

hugoberry's avatar
hugoberry
Responsive Resident
9 years ago

Using parameters as Anonymous was mentioning plus think about storing a file with connection string as its contents and store it in the same location for each of the client. Then on opening the PBIT the parametrs can be prepopulated with the contents of this stored file.

 

Otherwise you can think about a more (Power Query M) scripted approach where you parse PBIX/PBIT files, extract the query scripts do the replacements and figure out how to re-save that as a new PBIX/PBIT file.