On reports with tables from a custom connector, I’m getting Error 500 – Internal Server Error while uploading the report to Power BI Service, if incremental refresh is also enabled. As far I can tell, the error occurs when enabling incremental refresh, on the table sourced from the connector or any other table.
I didn’t find any documentation about using incremental refresh through/with a custom connector, so I would like to know whether is possible or not. Here’s a sample report; connector and test file which cause the error: Link
I’m using Power BI Desktop Version: 2.81.5831.821 64-bit (May 2020). Any help would be greatly appreciated.
@nickyvv, Thanks for the WooCommerce connector link. I was wondering how would a custom connector access the parameters (RangeStart and RangeEnd) required for the incremental refresh. I'll be sure to checking it out.
I appreciate the suggestion, but I’m unable to create a support ticket since I don’t have a Pro account.
@ahheroes, After all, I was able to create a support ticket with Microsoft. I haven't received a response saying incremental refresh isn't supported through custom connectors and they're still trying to debug the issue. Some of the debugging steps they suggested were uploading the report directly from the Power BI Service and trying to upload to a different workspace. As soon as I have a definitive answer, I'll post it here.