Forum Discussion

peterg0417's avatar
peterg0417
Helper III
3 years ago

Dataflow not detecting source file name change

I'm migrating my Power Query transformations to Dataflows, and while I'm doing that I'm also doing some maintenance/updating documentation.   I have 1 file (but possibly more) where I changed the n...
Need Help
peterg0417's avatar
peterg0417
Helper III
3 years ago

The M code was updated. This is why I'm posting for help.

 

The connection is "Dataflow->Sharepoint Folder->File123.csv"

 

  1. I changed the file name to "MasterFileName.csv" in SharePoint.
  2. The query connection in the Data Flow has been adjusted to "Dataflow->Sharepoint Folder->MasterFileName.csv"
  3. I then get an error message saying that file not found.

 

 

When I change "Domestic Portfolio - Master.csv" back to the old name that I used (which DOES NOT EXIST), it works.

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , peterg0417 

Thanks for your quick response! I test it in my side , when i update the file name in the sharepoint folder and then i refresh the dataflow , it return an error so it can detch the new file name:

 

 

If your file name is still unrecognizable after modification, you can try to click the "Refresh" button on Dataflow to clear the current query value and re-query.

 

If the latest file name is still not recognized, you can check what is the file name obtained in the previous step?

 

If the old file name is still displayed here, then you need to check whether your SharePoint file name has been changed successfully. Or you can try to create another Dataflow to connect to this SharePoint Folder to rule out whether it is a Dataflow problem.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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