Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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 bel...
Need Help
NimaiAhluwalia's avatar
NimaiAhluwalia
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hello Anonymous 

 

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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply

I tried even creating a new report and still got the error.

  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Hello Anonymous 

     

    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!

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Is it works well in power bi desktop with the same credential? This error can occur because of expired cached credentials. Clear your internet browser cache by going signing into Power BI and going to https://app.powerbi.com?alwaysPromptForContentProviderCreds=true . This forces an update of your credentials.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai