Forum Discussion

L_G's avatar
L_G
Helper I
5 years ago

Dataflow Refresh Failed

HI, I have a problem refreshing my First Dataflow on the Power BI Service. (I have a Premiun per User Licence) In my Dataflow I have multiple tables from the same data source (SQL Server) and many ...
Dataflow
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Super User
5 years ago

"I have multiple tables from the same data source (SQL Server) and many of them are merged each other or appended"

 

Have you considered using a SQL query , a view, or a materialized view for that part?

  • L_G's avatar
    L_G
    Helper I
    5 years ago

    Thank you Ibendlin for the advise! 

    I would also know why my dataflow can't refresh if I have computed tables in my dataflow..

    Is there something that I have to enable in order to solve this problem??

     

    Thank you in advance

    Luca.

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      what's the error message?

      • L_G's avatar
        L_G
        Helper I
        5 years ago

        Error: On-Prem execution not supported for entity '[my data]'  since it refers to another entity.. RootActivityId = '[...]'