Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to change connection to Power BI Dataset in Excel, using Analyze in Excel when moving Tenant

Hi All,

we are changing Office 365 Tenant, so I'll develop a new Power BI environment. As we use Analyze in Excel, is there a way to change the connection in the Excel file(s), so the current Excel files, connected to the Live Power BI Dataset will keep working/refreshing after I publish the same dataset in the new tenant? 

Thank you for your help, Kind regards, Suzan

Community Support
Community Support

Hi, @svanecht 


It’s my pleasure to answer for you.

I'm sorry that there is no good way to change it, and you need to use new tenant account to analyze in excel.

You can submit your idea here.Hope this feature will come soon.

Best Regards

Janey Guo


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

Helpful resources

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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


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.

Top Solution Authors
Top Kudoed Authors