topic Datamart started to keep failing the refreshes, details of refresh are blank in Report Server

Datamart started to keep failing the refreshes, details of refresh are blank

Draginko — Thu, 10 Aug 2023 07:52:14 GMT

Hello,

I am using datamart for enterprise wide report which is accessible by couple of thousands of people, and I have there scheduled refresh for every 6 hours. The datamart is used for preloading of data via ODATA protocol from one of the provider's database.

Normally, since we started to use this setup almost a month ago, approximatelly 20% of refreshes failed for unknow reason, and it was the reason to establish scheduled refresh 4 times a day, so we can ensure there will be proper refresh at least once a day. Six days ago, we had a line for couple of days where every single refresh was successful, and suddenly for last 3 days, every single refresh fails (even manually started).

The reason I am writing this post is, that I am not able to find out what is wrong, as there is no error message available, nor when I download that csv export which should contain details about refresh, this file is completely blank and contains only headers.

As to my knowledge, there have been no change in the configuration of providers database, not in the datamart configuration.

Any idea what can do, or what steps to take? Any information about what is causing this refresh to fail would be very helpful.

Re: Datamart started to keep failing the refreshes, details of refresh are blank

d_gosbell — Thu, 10 Aug 2023 09:36:16 GMT

The best approach here is to raise a ticket with Microsoft Support.

Re: Datamart started to keep failing the refreshes, details of refresh are blank

miraglia — Tue, 28 Nov 2023 21:37:25 GMT

I experienced the same error message. You can debug it if you copy the powerquerycode to powerbi desktop and run it from there. Usually this behaviour is by changing a datatype for example date or decimal number and they are errors.... so you have first to cleanup or filter invalid values and then make the change datatype. If in powerbi desktop it runs smoothly it will also work on datamart. Please also set under option the right locale