Forum Discussion
Importing an overwritten excel file
Just by way of update. I now download the new excel spreadsheet, and save as a xlxs file. I then copy the contents, and paste it into the original file.
Seems to be the easiest and quickest way, and is working well at the moment.
Thanks for all your suggestions. It's much appreciated.
Mitch.
Super UserStep 1) Open your dashboard file in Power BI Desktop (the application on your computer, not the website).
Step 2) At the top of the screen click Home, then look for a button called Transform data and click the small arrow underneath it.
Step 3) From the dropdown that appears, click Data source settings.
Step 4) You will see the old file path listed. Click on it once to select it, then click the button that says Change Source at the bottom.
Step 5) A window will open asking you to find the file. Navigate to where you saved SafetyCulture-Issues.xlsx on your computer and select it. Click OK.
Step 6) Click Close, then click Refresh at the top of the screen.
Not happening for me I'm afraid, I get:
Refresh10 queries are blocked by the following error:SafetyCulture-Issues-20260428-1The key didn't match any rows in the table.