Forum Discussion

William__K's avatar
William__K
Frequent Visitor
1 year ago

Power BI Service Refresh Failing

Hi all, Up until Monday, my Power BI Dataset would update without an issue as a scheduled refresh. It usually takes 80-90 minutes. However, the last 5 days have seen this error Data source error: ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi William__K ,

 

I want to acknowledge valuable input provided by lbendlin. I have some other thoughts to add:
Have you tried clearing the credentials to republish to the Power BI service and then refreshing it again and does it resolve the issue?

 

Best Regards,

Neeko Tang

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

William__K's avatar
William__K
Frequent Visitor
1 year ago

Hi Anonymous,

 

What permissions do you mean? 

Generally, I have cleared the cache on the report. I have deleted a lot of calculated columns that could have been causing an issue post download, as well as some applied steps. The refresh still restarts on Power BI Service but is fine on desktop. I am not too sure what else to do.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi William__K ,

     

    Sorry, I meant to try to reset the semantic model credentials. Does it solve the refresh timeout issue? If not please let me know.

     

    Best Regards,

    Neeko Tang

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

    • William__K's avatar
      William__K
      Frequent Visitor
      1 year ago

      Hi Anonymous,

       

      Thanks for your help so far. I reset the credentials for the SQL database that we use, but that didn't work unfortunately. It still downloads all of the data and then restarts the refresh soon after.