Forum Discussion

blitwak's avatar
blitwak
Icon for Helper I rankHelper I
3 years ago

Incremental Refresh is not working on Power BI Service

Hi- My soure are 10,000 Excel Files on SharePoint. Power BI takes 2 hours to refresh so I want to use Incremental Refresh. I dont understand why it tooks too much time. If Excel is on Folder /Cur...
Need Help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
3 years ago

This is why it works best with a relational database. When you do the RangeStart/RangeEnd filter, it sends back a SQL query to the server to only return the dates in that range.

 

When you run it against SharePoint, a CSV file, or Excel, it has to read all the data in then discard what it doesn't want. So for each of the 4 days you are doing, it is reading everything, then discarding all but one day, then repeats that 3 more times.

blitwak's avatar
blitwak
Icon for Helper I rankHelper I
3 years ago

I mean 4 days that I try to refresh data without success..

I created a datetime column before using RangeStart/RangeEnd filter on that column and this column is based on the folder (path).