PowerBI Datamodeling

[Anonymous]

Hi  All,

We have a requirement like when ever user inserts data in database it has to reflect in the  power bi report. They want to see the live data in power BI. I cannot use direct query mode as  this will impact the perrformance and also it has dax limitations.

so can you please help me to get this solved.

Thanks for your help in Advance.

[Anonymous · Accepted solution]

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.

[Anonymous]

Yes thats true . Can the hybrid model  helps  me  to implement this ? I am aware that hybrid model is still in preview but want to know the pros and cons of hybrid model

[AlexisOlson]

If you have to use Import rather than DirectQuery, you cannot have live data. You can set up automatic refreshes but these are limited to 8 per day or 48 per day with a Premium license.

Everything is a tradeoff. You can't have all the benefits of DirectQuery without the limitations. Life doesn't work like that.