PowerBI Datamodeling

Hi Anonymous ,

Agree with AlexisOlson .

You could refer to the official document to learn more information about composite model,

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

But the existing limitations of DirectQuery still apply when you use composite models. Many of these limitations are now per table, depending upon the storage mode of the table. For example, a calculated column on an import table can refer to other tables, but a calculated column on a DirectQuery table can still refer only to columns on the same table. Other limitations apply to the model as a whole, if any of the tables within the model are DirectQuery. For example, the QuickInsights feature isn't available on a model if any of the tables within it has a storage mode of DirectQuery.

More links:

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs

Is there a workaround for Power BI Desktop to automatically refresh data without publishing pbix to Power BI Service?

Auto Page Refresh in Power BI - Everything you need to know! - Data Mozart

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