Solved: Can't change the path of one file

amnd · ‎02-23-2018

I'm working on a Power Bi file which gets data from 4 different files (1 excel and 3 text documents).

I tried to open the excel file to change some data but it appeared a window that said "The file is corrupt and cannot be opened", I closed the window and retried opening the Excel and I could. Then I opened the PBI file and tried to change the path of the excel file and I couldn't.

I can change the paths of the text documents files but not the one of the excel.

(Before the window that appeared when I tried to open the Excel, I could change that path too)

What can I do?

parry2k · ‎02-23-2018

Interesting, couldn't reproduce at my end.

How about going to query editor -> ADvanced editor and then change the path in there in the script. Try that and see if it works.

That doesn't mean the issue your posted is resovled but want to check if that will work.

Thanks,

P

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎02-23-2018

What you mean that you cannot change path?

What error are you getting? Can you share some screen shot?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

amnd · ‎02-23-2018

parry2k · ‎02-23-2018

Interesting, couldn't reproduce at my end.

How about going to query editor -> ADvanced editor and then change the path in there in the script. Try that and see if it works.

That doesn't mean the issue your posted is resovled but want to check if that will work.

Thanks,

P

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Can't change the path of one file

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly