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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Sambath
Frequent Visitor

Can't connect to an Excel file in sharepoint after it had been moved and renamed

Hi Power BI gurus, 

 

I'm having an issue to reconnect to an excel file stored in SharePoint after it had been relocated and renamed. 

 

I created a report out of an excel file stored in SharPoint and now having some difficulty to reconnect to it after it had been relocated (to different folder) and renamed. I initially processed (renamed, recoded, removed columns, added columns, ...) the data in Power Query. In Power Query, I tried to reconnect to the file but it warned me that "You are about to create a navigation step that replaces the subequent steps. D you want to continue?" Once clicked Yes, it deleted all y data processing steps. 

 

Any idea how to reconnect to the file while keeping all the data processing steps? Or how to deal with relocated files, in SharePoint, in general in Power Query? 

 

Thanaks heaps in advance for any advice/assistance. 

1 ACCEPTED SOLUTION
tharunkumarRTK
Solution Sage
Solution Sage

@Sambath 
You can use the advanced editor to modify the URL and file name in the M-Code, if the structure of your data is same then the subsequent steps will execute properly.


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun



View solution in original post

4 REPLIES 4
Sambath
Frequent Visitor

Thank tharunkumarRTK. 

Sambath
Frequent Visitor

Thanks Tharun. Did just that but transformation steps were gone. 

v-junyant-msft
Community Support
Community Support

Hi @Sambath ,

You can update your datasource here:
1. In Advanced Editor:

vjunyantmsft_0-1708910789564.png

vjunyantmsft_1-1708910837117.png


2. Click the gear next to Source:

vjunyantmsft_2-1708910911130.png

vjunyantmsft_3-1708910931709.png


After updating the source path, verify if all your data processing steps are still intact. If any steps were lost during the update, you might need to reapply them manually. Unfortunately, if the steps were deleted during your initial attempt to reconnect, they would need to be recreated.

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

tharunkumarRTK
Solution Sage
Solution Sage

@Sambath 
You can use the advanced editor to modify the URL and file name in the M-Code, if the structure of your data is same then the subsequent steps will execute properly.


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun



Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.