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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.