Forum Discussion
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.
|
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
- NimaiAhluwalia
Continued Contributor
Hello dherman201
Hope you are doing good!
I got the same error message and got fixed.
In the Power BI service, go to dataset settings and check the data source credentials section. Click edit credentials and re-enter the credentials again then refresh the dataset. it will work.
If not then have a look at this bellow or else open a support ticket they might help you to troubleshoot the issue
https://community.powerbi.com/t5/Service/Refresh-Failed-Internal-Service-Error/td-p/381780
Also, have a look at this
https://community.powerbi.com/t5/Service/Error-Message-in-Service/m-p/1781201#M125796
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
- dherman201New Member
Thanks for the reply
I tried even creating a new report and still got the error.
- NimaiAhluwalia
Continued Contributor
Hello dherman201
The above solution helped many cases with a similar type of issue it not in your case then well you can try creating a support ticket for free if you are a pro user!
Regards,
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!