Forum Discussion
Helper IIIDataflow not detecting source file name change
Community SupportHi , peterg0417
According to your description, you connected a file in Power Query in a dataflow, and your file name may have changed, you want to connect to your new file.
First of all, for dataflow, it shows that you are the latest data of the current query. There is no need to clear the cache to refresh. If your file name changes, you need to go to your Power Query to modify the file name before you can connect to the new file. Otherwise, it will always is linked to the old file.
Power Query always reads the M code to obtain the corresponding data location. If you have not made any changes here, the old file data is always read.
By another you can also create a parameter to maintain your data source name , for this , you can refer to :
Create a parameter query (Power Query) - Microsoft Support
Parameters - Power Query | Microsoft Learn
Edit parameter settings in the Power BI service - Power BI | Microsoft Learn
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
Helper IIIThe M code was updated. This is why I'm posting for help.
The connection is "Dataflow->Sharepoint Folder->File123.csv"
- I changed the file name to "MasterFileName.csv" in SharePoint.
- The query connection in the Data Flow has been adjusted to "Dataflow->Sharepoint Folder->MasterFileName.csv"
- 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
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