Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Wolfiz
Frequent Visitor

How to convert pbix into pbit (automation process) + how stop refresh on pbix

Hello,

 

Let me explain our context; we are migrating some of our datasources set via odbc to synaspe, databricks, sql etc... hosted in azure.

The problem is that we've got around 1300 reports to migrate. that'sound weird if we ask to the people who create the report to rebuild it (it contains several table and their star schema are really heavy sometimes).

 

So to help them and speed-up the process, I would like to know if there is a way to convert a pbix to pbit without being force to open manually the pbi desktop , wait the refresh is done  and then save it in pbit.

By this way I will be able to script that in powershell , unzip the pbit , apply the changes based on some criteria and rezip it (and rename).

 

extra questions, when we open a pbix , each time it start by doing a refresh. Is there a way to prevent that ? Based on the report is can take more than 40min.

 

Thanks if you have a solution 🙂

 

Miguel

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi, @Wolfiz 

For your question, here are my answers:

Q1: For how to auto convert the .pbix to .pbit file ,you can refer to this document:

Automate the process of exporting Power BI files (... - Power Platform Community (microsoft.com)

Q2: If your Power BI Desktop connection mode is Impoet mode, Import mode will save our data in a .pbix file, so every time we open Desktop, we are not performing a refresh operation, but reading the data in the .pbix file, which is not how to cancel.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

Hi, @Wolfiz 

For your question, here are my answers:

Q1: For how to auto convert the .pbix to .pbit file ,you can refer to this document:

Automate the process of exporting Power BI files (... - Power Platform Community (microsoft.com)

Q2: If your Power BI Desktop connection mode is Impoet mode, Import mode will save our data in a .pbix file, so every time we open Desktop, we are not performing a refresh operation, but reading the data in the .pbix file, which is not how to cancel.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors