Forum Discussion

mohammed24's avatar
mohammed24
Frequent Visitor
3 years ago

Power BI RS Refresh fail- Incremental refresh not Possible

Hi there,

 

I'm encountering a refresh fail in one of my reports which is developed in Power BI RS version. The data takes over 4 hours to refresh. Whereas, in Power BI service the refresh gets timed out. 
One solution I came across for this was "Incremental Refresh". Incremental refresh will involve using Query folding on the data in Power query. But, since my data is Onpremise SharePoint List and I have used Odatafeed connector in Power BI desktop. I am unable to do query folding. Is there any solution to this?
Would really appreciate if there is a solution/Workaround to this  issue.

Thank You
Regards,
Mohammed

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • mohammed24's avatar
    mohammed24
    Frequent Visitor
    3 years ago

    Hi luisrh ,
    Thanks for the reply.
    However, My data source is SharePoint Onpremise list. I have tried query folding. The "Native query" option is greyed out for me. Although the article says that this necessarily mean that the data source does not support query folding. After I apply the steps and come to set a Incremental refresh the table dosen't show me the Incremental refresh option.
    Here:

    Do you think this has something to do with the version of PBI RS desktop im using?
    M Power BI Report Server version is :


    Really appreciate if you could answer this.

    Thanks

    Regards,
    Mohammed

  • luisrh's avatar
    luisrh
    Responsive Resident
    3 years ago

    I assume the version of pbi desktop you are using is because you are on PBI RS and using it there.   If you are using PBI.COM,  I would download the latest version of PBI desktop (You can have both Power BI desktop for PBI RS any version and PBI desktop latest version on the same machine).    Incremental refreshes works for me in Dataflows in PBI.COM with and OData endpoint.    I assume that the OData endpoint is accessible outside the firewall for your sharepoint list as well.   PBI.COM will need to be able to access it that way.