Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Hi @NSANAM -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
Proud to be a Super User! | |