Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Service Refresh failure

Hi,

 

We have reports on our Power BI Service, that refreshes every day from data that is stored in a Azure SQL Database. The databases is scaled-up when the refresh is triggered.

A scheduled refresh and also an on-demand refresh in the service is giving errors.

A refresh done in Power Bi desktop is working fine.

 

The error that is showed is always on a different table.

 

Any ideas how to find the route cause of this error. 

 

thanks

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Issue has been solved after contacting support. 

    PBI desktop was not triggering the error, the error was in a measure.

    Support was able to see the actual error message. It would be nice that you can see the actual error message in the Powerbi service and not a general one.

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Can you confirm that the database has completed scaling up before the refresh has completed?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes the scaling is complete. it was completed before the refresh is started. we're running on a S6 when the refresh is executing

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago

        Hi there

         

        It could be an issue with a particular table, what if you try and refresh it again?

         

        I am not sure why the error changes.

         

        If it does not resolve itself I would log a support ticket!