Connect my new dataset by changing my old connection string for a new one

[Anonymous]

Hello,
I have a particular technical question regarding the connection of a PowerBI dataset in an Excel file from the 'Analysis in Excel' functionality.
Originally, I have an Excel document containing a pivot table that was connected to a Cube on an SQL database. It's a classic connection string: Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Yyyyy;Data Source=Xxxxx;
The file contains several tabs built from this same source.

We are migrating to another solution and I have reproduced the same star schema found in the original Cube from the SQL source that I created in a dataset in Power BI to reproduce the same result using the 'Analysis in Excel' functionality. The result is interesting but I would like to know if it would be possible to simply disconnect my old Cube from my initial source and replace it with my new connection string from the Dataset in the data connection option of the Excel file. I wish I didn't have to rebuild all the filters and pivot tables so I was just hoping to change my connection string and see the same data again.

Here is my new connection string: Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=Whatever;Data Source=azure://api.powerbi.com;MDX Compatibility=1;Safety Options= 2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, UUuuuuuuuuuuuu;Update

I have tried to do it manually and I see that it is loading in Excel with my new connection string that I copy into the connections section of my old cube but that as soon as the loading is finished, the original connection resumes.

Is it technically possible to simply change the connection string in my Excel file to reconnect with my new data or do I have to redo all the pivot tables with filters for all the tabs?

[Anonymous]

Ok , thanks. I am still unable to login with the new connection string and perhaps, it because originally my Cube was in SSAS and all dimension tables in my model had ID keys and in my new preliminary dataset I use codes (that look unique) from each tables? So the model is different and refuses to connect to the Power BI service. I could try by recreating the exact same model to test.

[AlexisOlson]

Yeah, if you're connecting to a differently structured model, then you'll very likely need to re-build.

[AlexisOlson · Accepted solution]

I've tried swapping out connection strings before and I recall it working.

After you update the connection string, is it actually changing the connection string back to what it was? If not, then I'd recommend trying standard debugging procedures like saving the file, closing and reopening it, and hitting Refresh All in the ribbon (Data tab).