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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
karo
Advocate V
Advocate V

How to remove live connection from .pbix file ?

 Hi,

 

How we can remove live connection from .pbix file? 

I do not want to recreate entire report layout, but I need to change storage mode what is in use.  Is it even possible?

Please help.

 

Regards,

Karo

6 REPLIES 6
Thilini
Frequent Visitor

Hi,

 

Try super user manikuma34 solution. It worked for me.

 

Kind Regards,

Thilini

v-rzhou-msft
Community Support
Community Support

Hi @karo 

Switching from Live connection to Import mode currently is not supported.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function:Support switching SSAS connect model from "Connect Live" to "Import"

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Rico Zhou

 

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

 

manikumar34
Solution Sage
Solution Sage

@karo , 

Try the below method using Powershell. It worked for me. 

https://powerbi.tips/2020/05/hot-swap-power-bi-report-connections/

 

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Hi,

 

I tried your solution and it worked. I was trying so hard to remove the live connection because I don't want to recreate the entire report layout. IThis feature is not yet availbale in Power BI which is quite frustrating. But your alternative worked and I am soo glad I found this thread. Thank you very much!

 

Kind Regards,

Thilini

abdul_Kochi
Advocate I
Advocate I

Hi,

1. If you are trying to change the same file type then you can follow the same.

    a) File-->Options and settings-->Data source settings

    b) Change Data source.-->select new source file

 

If data source are same data type.JPG

 

If you want to change the source different file type ( for eg: instead of excel file, an sql data needs to use)

1. Get Data-->select new source file

2. Go to advanced edit query-->Advanced Editor and Copy the M code

3. Paste this code to old file source file.

 

If data source are different data type.JPG

 

 

 

 

 

 

Regards,

Abdul

DataZoe
Microsoft Employee
Microsoft Employee

@karo Have you tried to change them to import using the storage mode?

Use storage mode in Power BI Desktop - Power BI | Microsoft Docs

 

Otherwise, it is possible to change out the connection in the Power Query Advanced Editor. I usually create a new table to the new source, then in advanced editor find the connection part. Now I go and replace the existing tables to the new connection in that part of their advanced editor code. 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.