Troubleshooting unsupported data source for refresh

You might see an error when trying to configure a dataset for scheduled refresh.

You cannot schedule refresh for this dataset because it gets data from sources that currently don't support refresh.

This issue happens when the data source you used, within Power BI Desktop, isn't supported for refresh. You need to find the data source that you're using and compare that against the list of supported data sources at Refresh data in Power BI.

Find the data source

If you aren't sure what data source was used, you can find that using the following steps within Power BI Desktop.

  1. In Power BI Desktop, make sure you are on the Report pane.

    Screenshot shows the Power BI Desktop report pane.

  2. Select Transform data from the ribbon bar.

    Screenshot shows the Transform data option of the Home ribbon where you can edit queries.

  3. Select Advanced Editor.

    Screenshot shows the Advance editor option of Power Query Editor.

  4. Make note of the provider listed for the source. In this example, the provider is ActiveDirectory.

    Screenshot shows the Advanced Editor with the source provider highlighted.

  5. Compare the provider with the list of supported data sources found in Power BI data sources.

Note

For refresh issues related to dynamic data sources, including data sources that include hand-authored queries, see Refresh and dynamic data sources.

Next steps

More questions? Try asking the Power BI Community