Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Best practice Power BI Dataflows Architecture

Dear community,    info:  - 10 factories, each has a own Sharepoint folder with 12 Excel files for every month - Every Excel file has 5 different tables - Power Automate is blocked in my organiz...
  • v-xiaosun-msft's avatar
    3 years ago

    Hi Anonymous,

     

    A Power BI Premium subscription is required to refresh more than 10 dataflows across workspaces.

    Refresh limits for shared dataflows are limited to two hours per entity and three hours per dataflow.

    For Power BI Premium, the only limit for Power BI Premium is 24 hours per dataflow refresh.

     

    I think you can refer to the following documentation that may be helpful to you.

    Dataflow best practices - Power BI | Microsoft Learning

    Solved: All tables to dataflows - Microsoft Power BI community

     

    Best Regards,
    Community Support Team _ xiaosun

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

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    There are two types of refreshes applicable to dataflows: Full and Incremental (Premium only).

    For Power BI Premium, guidance and limits are driven by individual use cases rather than specific requirements. The only limit for Power BI Premium is a 24-hour refresh per dataflow.

    Moreover, there are some considerations when you refresh dataflows in Premium. Please reference the following document.

    Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

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