Forum Discussion
Responsive ResidentBI Report Won't Refresh in Service
I think I finally resolved this issue. I found a date that had a NULL value. I replaced the NULL date value and made sure that the data type was set to 'Date'. Desktop refresh worked as expected. Published the report to Service. Now the report is refreshing as expected in Service.
So my guess is that date with the NULL caused the error.
I'm having the same issues in my report. I use a few connections including SQL Server, Web Connection, and an ODBC Connection. There are no refresh issues when refreshed in desktop, but it refuses to work in services. I've double checked that the privacy settings are set to organizational for both services and desktop and all connections and they all are. I need this scheduled refresh to work, has anyone solved this?
Here is the error message I receive:
Unable to connect to the data source undefined.
Cluster URI: WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 35d4da93-3ebb-4c18-b48e-297598ce7862
Request ID: dee745e9-960c-e9dd-3850-f8be5ae4a322
Time: 2023-02-25 17:13:11Z
IamTDRI just completed a try and error session of loading the report from Desktop to Service taking out steps until I determined the root cause of my error.
As I stated below, my issue was that in Power Query I used #date(). I needed to do this step to break out my companies Sales in buckets based on release dates. Worked great in Desktop. Published the report and never worked.