Forum Discussion

dherman201's avatar
dherman201
New Member
5 years ago

BI data query to a CKAN database -refresh stopped working

Hello

I have built a few BI reports accessing a CKAN database.  They are set to refresh daily. As of a few weeks ago the refresh started failing.

The message that are returned seem to vary, but below is one of them.  

I also get the message  "Access to the resource if forbidden"

 

I've tried connecting to the source agian through Power BI  "Get Date" sending in the authorization string and I get the same error.

 

However I can go to Postman and using the same URL and authentication credentials, it works fine.

I'm sort of new to PowerBI so if I've left out any information, please just ask.  I did nothing to change the query.   Also it seems to be happening to multiple reports that have been working and refresshing for months.  They are not all accessing the same data from the CKAN site but they are all from the same site.

Appreciate any assistance.

 

Here is the email that I am getting when the refresh fails:  PDS KPI is the name of a report.
PDS KPI has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The credentials provided for the Web source are invalid. (Source at http://www.civicdata.com/api/3/action/datastore_search.). The exception was raised by the IDbCommand interface. Table: PRE-APP.

Next refresh for PDS KPI is scheduled for April 15, 2021 7:00 UTC.

 

Learn more >

 

Technical Information

 

Activity Id:

c50c8bf8-3760-40d3-98c0-a18e308437c4

Request Id:

94f09e29-5af1-4810-b98d-cb0b9d71d9c7

Cluster Name:

WABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.net

Refresh Start Time:

April 14, 2021 7:01 UTC

Refresh End Time:

April 14, 2021 7:09 UTC

4 Replies