Refresh Error

[beaoliv123-_]

Hi everyone,

Does anyone know how to solve this error: 

• Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}}

This is the error that power bi gives me when I try to refresh a report online. I have the incremental refresh configured, the native query is working perfectly, and I have the data filtered to just appear the last 3 months. Also, the incremental refresh gives me the data from last day. So, in terms of performance, I though this could help a lot. I can always refresh the report on the desktop, but when I try to do it online, it always gives me the same error.

Thanks a lot

[beaoliv123-_]

Hi, how do I do that?

Thanks

[lbendlin]

- install DAX Studio

- run it and connect to the dataset via the XMLA endpoint URI (you can get that from the Server settings in the dataset's settings page)

- View...Metrics

- click on partitions

- observe the number of partitions (needs to be more than one for the incremental refresh tables)

- check the last processed date for each partition

[lbendlin]

I can always refresh the report on the desktop

When you do that you must be aware that if you choose to publish the report to the workspace this will reset the incremental refresh process.

Use DAX Studio or SSMS to validate that Incremental refresh is setup correctly and working, by comparing the refresh timestamps of your partitions. If they are the same or you only see one partition then incremental refresh is not happening.