Live connection in Power BI with semantic models

[Anonymous]

Hi Team,

I am connecting PBI desktop with PBI semantic models using live connection, could you please help what all dax and Power query limitation will be there while working on such cases.

Regards,

Azad

[Idrissshatila]

Hello @Anonymous ,

Some of the limitations associated with Power BI LIVE Connection are given below:

• You are also limited to only one data source/database in Power BI Live Connection. Data from multiple data sources cannot be combined any longer.
• Power Query transformations are not available with Power BI Live Connection. In fact, in the Power BI Live Connection mode, Edit Queries and all related options are disabled. Because any changes you want to make to relationships or the query editor should be done in Analysis Services rather than Power BI.
• Before loading data into the SSAS model, all data transformation requirements must be met. Because SSAS is not a data transformation tool, you can use SSIS to transform data before loading it into the data warehouse, and subsequently process the data from the data warehouse into an SSAS data model.
• The relationship tab is not available with the Live Connection. In this mode, Power BI is reduced to a mere visualization tool.
• Modeling in Power BI is severely limited when using the Live connection. Only measures can be created. Report Level Measures are the type of measure that you can create with a Live Connection. Report Level Measures, as the name implies, are only applicable to this Power BI report. You cannot use the report level measures built in the previous Power BI report if you create another Power BI report that is connected live to the same data source.

check the full blog that has all the info https://hevodata.com/learn/power-bi-live-connect/#limit

[Anonymous]

Thank you @Idrissshatila for clarification on this, Do we have any limitation on time intelligence dax functions in live connection likewise direct query. (for Power BI semantic models only)