Forum Discussion

FotFly's avatar
FotFly
Icon for Helper II rankHelper II
2 years ago

Power BI semantic model refresh fails.

Hi,

I published a report to the Power BI service yesterday and when I hit the On demand refresh button I get the following error.
The thing is that the project refreshes on Power BI desktop but not in service. All data come from SQL tables and all datasource credentials are updated in service. The table that is mentioned at the end, and I have hidden for confidentiality reasons, has no problem running in any other projects.

It will be really helpful if you had an idea of why this might happening.

Thanks in advance

 

Need Help

6 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Icon for Super User rankSuper User
    2 years ago

    There are certain transformation that work in power bi desktop but not in power bi service. Can you narrow down to which table/query is causing the problem, and elaborate on how that query is created?

    Even if the error message specifies table X, sometimes it is not true. But try removing table X from the model, republish/refresh and see if that is the query that is giving you issues.

    • FotFly's avatar
      FotFly
      Icon for Helper II rankHelper II
      2 years ago

      Hi,

      Thank you for your reply.
      I did remove the query and reuploaded the report and it refreshes without issues this time. However, this should not be happening. The query gets data from an sql table and then I just perform a merge with another query to filter out some rows. This is a common practice and I do not understand why it causes that issue.

      • Tutu_in_YYC's avatar
        Tutu_in_YYC
        Icon for Super User rankSuper User
        2 years ago

        Odd... but just fyi, another reason why a merge doesnt work in the service is when the tables/query/data source have different privacy settings.