binary and connect pbix file to new pbix model

[gidon]

Hello

i have a pbix model which is steady  base.pibx  .

i want to start new model ( power bi doc )  data.pbix

i want to strat with the base model , so i have all my base tables ready .

in qlik we used binary connect

thanks

gidon

[Greg_Deckler]

I believe you want to save your base.pbix as a template file. You can then use the template file to create the data.pbix file.

[gidon]

Hi

It is something like a templet

the base.pbix will be basic tables of erp system like

part , categoies , customers , suppliers and more

data will invoices , orders

and more , in qlik do it all the times , is make delepment  better and easier .

so can it be done , and how ?

thanks

gidon

[gidon]

Hi

can it be done ?

gidon

[v-shex-msft]

Hi @gidon,

As smoupre's said, you can save the base pbix file as a template.

1. Click on "file", choose "Save As".

2. Choose the template type to save.

Regards,
Xiaoxin Sheng

[gidon]

I  Xiaoxin

I understand , templet is a documnet , that you load to new document and bring all queries  .

But I need better than that I Come fro qlikview world , there is a great feature that

binary connect a document  to another document , it does not load again all the  queries  .

i have a batch file that run sequese of qlik documents that , doc2  bianaty connect to doc1 , doc3  connect to doc2

doc1 will have all basic tables ready , doc2 will bring Invoices line transactions doc3 will bring stock transactions .

so it is not really template  ,  it is great for developers  and debug

in qlik it is called binary connect

thanks for the help

gidon

[v-shex-msft · Accepted solution]

Hi @gidon,

>>i have a batch file that run sequese of qlik documents that , doc2  bianaty connect to doc1 , doc3  connect to doc2

doc1 will have all basic tables ready , doc2 will bring Invoices line transactions doc3 will bring stock transactions .

I have a idea to solve your issue, you can store other config to xml file,connect to this xml file and analysis xml to connect other databases, then save it as a template(this method is from @suvaries). You can use this template to connect the dynamic databases.(change the config xml to change connected database.)

For example(use xml config file to connect sqlserver).

power query:

let
    configPath = "C:\...\Desktop\config.xml",
    Source = Xml.Tables(File.Contents(configPath)),
    Table0 = Source{0}[Table],
    #"Changed Type" = Table.TransformColumnTypes(Table0,{{"server", type text}, {"database", type text}}),
    Table1 = #"Changed Type"{0},
    server= Table1[server],
    db = Table1[database],
    databaseCon = Sql.Database(server, db),
    dbo_xxx = databaseCon{[Schema="dbo",Item="xxx"]}[Data]
in
    dbo_xxx

config file:

<root>
  <connection>
    <server>localhost</server>
    <database>dbxxx</database>
  </connection>
</root>

Notice: you can also store the path of other config file which use to connect the database.

<files>
  <list>
    <config1>C:\...\Desktop\config1.xml</config1>
    <config2>C:\...\Desktop\config2.xml</config2>
    <file1>D:\...\file1.txt</file1>
  </list>
</files>

Regards,

Xiaoxin Sheng

[gidon]

Thank you

i need to learn more about DAX

let you know in few days

Gidon