Skip to main content
Microsoft Idea

Power BI

Needs Votes

refresh specific data source

Vote (45) Share
Power BI User's profile image

Power BI User on 22 Sep 2015 03:00:43

Allow us refresh Specific Data Source!
We have multiple sources of tables, in case I have update of Dimension, I want to update only dimension table, and not whole model. Current workaround - delete dimension and add new table is tedious

Comments (4)
Power BI User's profile image Profile Picture

s F on 05 Jul 2020 23:56:05

RE: refresh specific data source

The OP is a little unclear.

We need the ability to disable data refresh for individual data sources in the web service. Some data sources are unchanging and don't require refreshing.

Currently this is only available in the desktop service with the "Include in report refresh" option unticked, oddly it doesn't cascade into the web service when you publish.

Further, a failure of a single data source should not cancel the rest of a refresh cycle.

Power BI User's profile image Profile Picture

Stuart on 05 Jul 2020 23:41:16

RE: refresh specific data source

Struggling with this too. Looks like I've worked my way to a potenital solution whereby I have to invoke the rest API to add rows to volatile dimensions.

Would have been better to extract the dimensions to a different datasource and force a refresh on the datasource, not the complete dataset

Power BI User's profile image Profile Picture

Bennie Lopez on 05 Jul 2020 23:07:22

RE: refresh specific data source

I thought this would have more votes:)
I have reports with multiple data sources, some sources need to be refreshed daily, while for others it makes sense to only do weekly
Currently, there is no option to have a separate refresh schedule per data source
Please vote

Power BI User's profile image Profile Picture

Nguyễn Minh Trí on 05 Jul 2020 22:40:28

RE: refresh specific data source

out of votes but agree