Solved: Warehouse: Refresh default dataset

cw88 · ‎07-28-2023

Hi,

how can i refresh the default dataset? Last refresh is shown in workspace, but no possibility to update:

In the dataset i can also only view the history:

When i connect from excel, no tables are displayed.

Thanks!

Anonymous · ‎07-28-2023

There's no Refresh option because default dataset does not work in Import mode so there's no data to refresh (I think the "Refreshed" attrubite of this dataset always show the creation date).

To update the list of tables in a default dataset open your warehouse, navigate to the Reporting tab at the top, click "Manage default Power BI dataset", check your tables and confirm, and then click "Automatically update dataset".

View solution in original post

Anonymous · ‎07-28-2023

There's no Refresh option because default dataset does not work in Import mode so there's no data to refresh (I think the "Refreshed" attrubite of this dataset always show the creation date).

To update the list of tables in a default dataset open your warehouse, navigate to the Reporting tab at the top, click "Manage default Power BI dataset", check your tables and confirm, and then click "Automatically update dataset".