Combining secondary datasets with large datasets

Hi Anonymous ,

From the Microsoft official document, we know Composite models allows a report to have multiple data connections, including DirectQuery connections or Import, but not supports Connect live mode.

So in your scenario, if you connect to Tabular model using Import mode, it is supported to create composite model to connect to other data sources referred above.

While note that Power BI Pro or Power BI Free supports uploading Power BI Desktop (.PBIX) files that are up to 1 GB in size. Power BI Premium supports uploading Power BI Desktop (.PBIX) files that are up to 10 GB in size. If you need to upload PBIX file that is larger than 10 GB, consider to move data from your source to SQL Server, Oracle or SSAS, then use DirectQuery/Live connection.

As a workaround, you may use the dataflow in Power BI Service to connect to the tabular model using connect live mode and other data sources referred above, then you can create reports in Power BI Service. You may need install and configure enterprise gateway for the dataflow.

Note: Dataflow capabilities are available for Pro and Premium licenses. To access dataflow premium features, dataflows must first be enabled for the relevant capacity. See more Configure and manage capacities in Power BI Premium.

Best Regards,

Amy

Community Support Team _ Amy

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