Skip to main content

Power BI

New

refresh specific data source

Vote (43) 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

53e3eec9 1325-4714-84ee-67156e1f4516 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

5b8c7c4f 0b40-401c-a727-a81d9f2ddfd3 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

5e24d030 ee76-4abb-9f69-ce41003fbbbd 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

5dc3e78d 80d0-4ff8-b584-1856d97d9cd7 on 05 Jul 2020 22:40:28

RE: refresh specific data source

out of votes but agree