Forum Discussion
Increment Refresh Clarifications
Yeah, sorry GK600 - I understand. That is how it goes with self service projects. If you can get the system to export in to Excel format or CSV format, you can get things working, but there will be no incremental refresh on those either, the point of your original post.
If you have any problems going forward, start a new thread and we will jump in and help. In the mean time, please mark one or more of these posts as the solution so this thread can be marked as solved - even though not solved in the way you were hoping. 😉
Do the Excel export then. That is same as CSV from Power Query's perspective on performance.
But ideally if you can get the data directly, that will be much better. You'll have to install a gateway most likely for the service to refresh, so it may be a bit of a hard sell initially if your IT department hasn't embraced Power BI/Power Platform and understand how data access works through the cloud.
Thansk edhans again.
As I suspected, supplier cant provide data in any other way. IT team doesnt have even time to look at any such requests as of now.
In order to proceed, I will have to follow manual process of importing data in excel or CSV then. I thought CSVs are lighter. Anyway, I at least know what to do now.
Thanks again for your time to respond.
Gaurav
Yeah, sorry GK600 - I understand. That is how it goes with self service projects. If you can get the system to export in to Excel format or CSV format, you can get things working, but there will be no incremental refresh on those either, the point of your original post.
If you have any problems going forward, start a new thread and we will jump in and help. In the mean time, please mark one or more of these posts as the solution so this thread can be marked as solved - even though not solved in the way you were hoping. 😉