Reply
Frequent Visitor
Posts: 2
Registered: ‎05-09-2018
Accepted Solution

Partial Data-source Refresh

Hi everyone!

I have a report where I am pulling data from multiple data sources.

 

Most of this is fine, as I am getting data from the web (kobo toolbox), from 9 data-sources (all formated similarly and appended). Everything refreshes normaly.


The problem is that i also have several .XLS data sources (also formatted and appended ) that work fine in BI Desktop, but there is a problem when refreshing the dataset through the service.

 

This .XLS data does not need to be refreshed. They are old back-up files that are useful in terms of statistics and vizualisation, but that are never updated. 


I can't "enter" the data directly into BI Desktop (too many columns), nor can i upload it as a dataset to the BI service (it does not allow me to create reports with BI service data and other live data).

 

As it is impossible to "tell" the service only to update data collected from the web, and leave the .xls files alone (do not refresh), what would be your proposal on solving this in terms of best practice.

 

Move the .XLS to OneDrive, Sharepoint, Dropbox...? Is there something more obvious that I am missing?


Thank you in advance!
Zeljko


Accepted Solutions
Community Support Team
Posts: 6,994
Registered: ‎05-02-2017

Re: Partial Data-source Refresh

Hi Zeljko,

 

There is a new feature under preview called "Incremental refresh". Surely it has some limitations for now. I wounder if it could help in your scenario. You can give it a try. Please refer to power-bi-desktop-may-2018-feature-summary/#incrementalRefresh.

 

Best Regards,

Dale

View solution in original post

Highlighted
Advisor
Posts: 288
Registered: ‎01-16-2018

Re: Partial Data-source Refresh

[ Edited ]

Hi @zbareta,

 

@v-jiascu-msft is correct, you can use this feature and I suggest you concentrate on Detect data changes part:

 

complete-periods.pngInremental refresh

Be aware that it is applicable for all Power BI Premium and Power BI Embedded capacities (starting from A3). 

 

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

View solution in original post


All Replies
Super User
Posts: 2,655
Registered: ‎06-24-2015

Re: Partial Data-source Refresh

Hi there

Currently Power BI will refresh all the data in the model and there is no way to only refresh selected data.
"Proud to be a Datanaut!"
Community Support Team
Posts: 6,994
Registered: ‎05-02-2017

Re: Partial Data-source Refresh

Hi Zeljko,

 

There is a new feature under preview called "Incremental refresh". Surely it has some limitations for now. I wounder if it could help in your scenario. You can give it a try. Please refer to power-bi-desktop-may-2018-feature-summary/#incrementalRefresh.

 

Best Regards,

Dale

Highlighted
Advisor
Posts: 288
Registered: ‎01-16-2018

Re: Partial Data-source Refresh

[ Edited ]

Hi @zbareta,

 

@v-jiascu-msft is correct, you can use this feature and I suggest you concentrate on Detect data changes part:

 

complete-periods.pngInremental refresh

Be aware that it is applicable for all Power BI Premium and Power BI Embedded capacities (starting from A3). 

 

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Frequent Visitor
Posts: 2
Registered: ‎05-09-2018

Re: Partial Data-source Refresh

@v-jiascu-msft @zoloturu Thanks a million. Will deffinitely give it a shot!

 

All the best!