Forum Discussion
PowerBI Datamodeling
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.
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
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.
3 Replies
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.
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
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.
