Power BI – Could not find file ‘C:\temp\AdventureWorks_Territories.csv’.

-> I opened a Power BI report and clicked on Refresh and got below error,

AW_Territories_Lookup – Could not find file ‘C:\temp\AdventureWorks_Territories.csv’.

-> I checked the file “C:\temp\AdventureWorks_Territories.csv”. It seems like someone have renamed the file to “C:\temp\AdventureWorks_Territories_AW.csv”.

-> One way to solve this issue is to rename the file from AdventureWorks_Territories_AW.csv to AdventureWorks_Territories.csv in location C:\temp.

-> In my case that was not possible as the team who changed it have used it on other reports.

-> Hence in my Power BI report, I clicked on “Transform data” and clicked on “Data source settings”.

-> I clicked on the file “C:\temp\AdventureWorks_Territories.csv” and clicked on “Change Source”.

-> Once the above changes are completed. Clicking refresh will just complete fine.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s