Import data from PowerBI semantic model

[Anonymous]

Hello team,

I am attempting to import data from Power BI Semantic to merge it with other datasets and perform some transformations. However, I am encountering an issue as Power BI only permits connections to the semantic model in Direct Query mode. Could someone assist me in finding a resolution for this?

[rajendraongole1]

Hi @Anonymous -The best solution depends on the size and complexity of your datasets and the level of integration/transformation required. For simpler cases, Dataflows or Composite Models can be effective. For larger-scale needs, consider exporting via SSMS or using a Data Warehouse for intermediate processing. If you share more details about your data and requirements

Dataflows allow you to persist data, enabling merges and transformations without the DirectQuery limitations.Reduces the complexity and data transfer volume by summarizing data in the model.

reference links:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-discourage-directquery-connections-to-dataset