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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
hours5209
New Member

dataset connect to onedrive excel

My dataset was created from PowerBI web and connect to excel on onedrive.

If the excel was updated by overwrite, the dataset refreshed well.

 

These days I deleted the file first and put a new one with the same name in the same folder, but the dataset connection seems missed.

 

I could not access Query Editor from PowerBI web and also unable access the dataset and update connection through PowerBI desktop.

How could I re-connect the file or if I would like to connect to another file, how could I do?

2 REPLIES 2
Stachu
Community Champion
Community Champion

you can connect to the new file in a new query and later copy the connection string to the original query using Advanced Editor



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Hi @Stachu , thanks, could you please teach me how to go to the "Advanced Editor" on web BI?

Thank you very much.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.