Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Power Bi Metadata

Hi All,


I am attempting to use a single .pbit file to hold changes to formatting and visuals and then create multiple .pbix files from the .pbit file. These .pbix files would each use different databases and I was attempting to automate the connections used by editing the database in the metadata file DataModelSchema. I am successfully able to see the database name change when the file is unzipped and zipped back up but I am recieving an encryption error when attempting to connect to the database when opening the file. 


Is there something additional that must be edited in the metadata to allow the change in database to connect when opening the template, or is changing the database in the metadata corrupt the file?





Community Support
Community Support

This may be caused by the securitybindings file.

Please try replace the original zip file with the modified file, delete the securitybindings file, and then rename to .pbix. Avoid decompressing and compressing the original file directly.

After I changed the .Pbit to .Pbit.Zip, I copied the DataModelSchema and edited the database connection and replaced the file that was in the file and then removed the SecurityBindings file. When I renamed the file back to .pbit/.pbix the connection still appears to not work as the encryption error is still ocurring with the authentication.

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!