Best practice with dataflow and dataset

Hi tannhq,

May I know which official document are you referring to? In the dataflows and composite model official docuemnts, I don’t find such limitations.

Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Docs

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

Normally, if you see the following popped bar, it means you don’t apply the changes in Power Query Editor(Transform Data) to Power BI Desktop. You need click on Apply changes to load the changes into the model.

If you would like to combine all your dataflows into one dataset, there are these strategies normally.

1 Create a dataflow based on all the upstream dataflows, and then build a dataset on it, which is supported by Premium.

Creating a dataflow - Power BI | Microsoft Docs

2 Combine the dataflow data in Power BI Desktop, but due to the large data amount, I would suggest you take Direct Query mode to the dataflows.

Using DirectQuery with dataflows - Power BI | Microsoft Docs

For your data amount is large, I would suggest you the first strategy as prefer.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun