Forum Discussion

PWasniewski's avatar
PWasniewski
Regular Visitor
6 years ago
Solved

Dataflow limitations in Power BI Pro

Hi Everyone!   due to some refreshing problems of the dataflow I have a question, for which I couldn't have found answer in manuals or open internet.   Are there any limitations for dataflows in ...
Dataflow
  • PWasniewski's avatar
    PWasniewski
    6 years ago

    Hi v-eachen-msft 

     

    Thank You for Your response! 

    The refresh failed after ~30 min, so it's far from the 2h edge 🙂

    Second tip is more convenient, but I have used other solution - I have reduced the queries from that biggest table, and after that  refreshing has finally finished correctly.

    Thank You once again!

     

    Regards,

    Piotr

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi PWasniewski ,

 

I think you ran into the refresh time out( 2 hours ). 
You could broke up a big model into entities in 5-6 different dataflows in the same workspace. Then stagger the refresh time.

 

PWasniewski's avatar
PWasniewski
Regular Visitor
6 years ago

Hi v-eachen-msft 

 

Thank You for Your response! 

The refresh failed after ~30 min, so it's far from the 2h edge 🙂

Second tip is more convenient, but I have used other solution - I have reduced the queries from that biggest table, and after that  refreshing has finally finished correctly.

Thank You once again!

 

Regards,

Piotr

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi PWasniewski ï¼Œ

     

    I am glad that you could find a solution. You could accept your own reply to let other users find it more quickly.