Forum Discussion

haqv's avatar
haqv
New Member
1 year ago
Solved

Schedules/On-demand refresh failed

Hello Power Bi team,   I had a Pbi report with size of 800mb. Data is connected to PBI report via sharepoint folder gateway. My data is about 3Gb-5Gb for 3-year transactions. I publised my report t...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    1 year ago

    haqv 

    Incremental refresh with sharepoint or onedrive is not feasible though there are few workarounds, pelase follow the instructions in this video and see if there is anything wrong in the implementation 

    https://www.youtube.com/watch?v=6Uy59RsqgrM

     

    I would suggest you not to perform the full load during the initial refresh, rather perform the bootstraped refresh i.e. truncate the dataset and perform the first load. This will create empty partitions in the power bi service. Then refresh the partitions one after the other. Instructions are here

    https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#prevent-timeouts-on-initial-full-refresh

     

    Considering you are using data gateway, and your sources are excel files, make sure your gateway server has sufficient resources to perform the data refresh.

     

    Need a Power BI Consultation? Hire me on Upwork

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi haqv,

 

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.

 

Warm regards,

Prasanna Kumar