cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karo
Advocate III
Advocate III

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

4 REPLIES 4
RicoZhou
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
Super User I
Super User I

@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!




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
Super User II
Super User II

@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,
DataZoe


See my reports and blog at https://www.datazoepowerbi.com/

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors