- Check the actual source path used by Power BI.
- A local OneDrive folder and the online file are different connection targets.
- Test source access and refresh in the service after publishing.
Noble Desktop instructor Dan Rodney explains the difference between refreshing local data and using an online source. This preview introduces the source-path problem; the written guide adds a practical checklist for diagnosing it.
Develop reporting and data connection skills in the Power BI Certification program.
This is a lesson preview only. For the full lesson, purchase the course here.
Why Desktop Refresh Can Work While Service Refresh Fails
Power BI Desktop runs on your computer, where it can read files available to that computer. The Power BI service runs online. Publishing a report does not automatically give the service access to every local file that Desktop can read.
This distinction is the central idea in the video. Before troubleshooting a schedule, identify the source that the model actually uses. A successful local refresh proves that your computer can reach that source. It does not prove that the published model has the same access.
Understand the Local OneDrive Folder
OneDrive keeps a local folder synchronized with an online copy. When you browse to a workbook through your computer's folders, you can select the local copy even though its folder name contains "OneDrive."
In the lesson, the source settings reveal a path on the instructor's C drive. That is a local file path, not an online address. Power BI Desktop can use it on that computer, but the service cannot simply browse the same C drive.
The useful question is not just "Is this file in OneDrive?" It is "Which copy and connection does this model use?" Inspect the source settings to answer that question before changing refresh settings.
What Publishing Adds
For an imported model, publishing sends the report and its semantic model to the service. The model includes the imported data and the modeling work used by the report. Refreshing the published model then requires access to its configured sources.
If you manually refresh in Desktop and republish, you can send updated imported data to the service. That is a manual workflow. An automated workflow needs a source connection the service can use and a working refresh configuration.
Connect to the Online Source Deliberately
The lesson prepares an Excel workbook in OneDrive and explains why the online file link matters. For OneDrive for work or school, Microsoft documents a supported web-link workflow: obtain the file path from OneDrive, use the Web connector in Desktop, and authenticate as required.
Use Microsoft's OneDrive connection instructions for the exact steps in your environment. A generic sharing link and a file path are not interchangeable in every workflow. Account type, connector, and authentication requirements matter.
After establishing the connection, revisit Data source settings and confirm that it identifies the intended online source. The presence of a OneDrive folder on your computer is not enough evidence by itself.
When a Gateway May Be Needed
A source that remains on a local computer or an internal server may require an on-premises data gateway so the service can access it through a supported connection. The video introduces that option but does not demonstrate gateway setup.
A gateway is not a requirement for every cloud source, and using a cloud file does not eliminate every possible connection or credential problem. Choose the connection approach appropriate to the actual source and involve the person responsible for that environment when configuring it.
Test Refresh Before Setting a Schedule
- Confirm which source path and connector the model uses.
- Refresh in Desktop and verify that the report reflects the expected data.
- Publish to the intended workspace.
- Configure the service connection and credentials, including a gateway when required.
- Run a manual refresh in the service and inspect its outcome.
- Configure the schedule only after that service refresh succeeds.
Use a small, known source change for your test when you are authorized to edit the data. Record what should change in the report and confirm it after refresh. A completed operation is easier to assess when you know the expected result.
Separate File Synchronization from Data Refresh
OneDrive synchronization keeps file copies aligned. Power BI data refresh updates the model from its sources. These are related processes, but a file being synchronized does not prove that a model has refreshed successfully.
Microsoft's OneDrive and Power BI refresh documentation explains another related case: storing a Power BI Desktop file in OneDrive or SharePoint Online. Check which workflow you are using before applying instructions intended for a different file type or connection.
A Short Troubleshooting Checklist
- Is the model pointing to a local path or an online source?
- Does the service have the required connection and credentials?
- Is any required gateway available?
- Did the most recent service refresh succeed?
- Does the report show the specific source change you expected?
If the report uses a database, the Import versus DirectQuery guide helps explain a different part of the decision: whether data is stored in the model or queried from the source as needed.
This guide is adapted from Noble Desktop's online-source refresh lesson. The public video is a preview, not the complete course lesson.