Forum Discussion
Dynamics 365 connection
Hi Anonymous ,
As far as I know, Power BI support us to connect to Dynamic 365 by import connection mode. We need to consider whether your capacity support the increasing amount of data. Larger model sizes may not be supported by your capacity. Shared capacity can host models up to 1 GB in size, while Premium capacities can host models up to 13 GB in size. For further information, read the Power BI Premium support for large datasets article.
Here is an offical blog about how to optmize Import model.
So if the size of your data is larger or will be larger than size of your capacity. You may need to consider to use Direct Query or Live connction mode.
As you mentioned, load your data into Azure SQL database then you can use Direct Query connection mode to connect to Azure SQL database.
Here is an offical blog about how to optmize Direct Query model.
For reference:
Optimization guide for Power BI
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
As far as I know, Power BI support us to connect to Dynamic 365 by import connection mode. We need to consider whether your capacity support the increasing amount of data. Larger model sizes may not be supported by your capacity. Shared capacity can host models up to 1 GB in size, while Premium capacities can host models up to 13 GB in size. For further information, read the Power BI Premium support for large datasets article.
Here is an offical blog about how to optmize Import model.
So if the size of your data is larger or will be larger than size of your capacity. You may need to consider to use Direct Query or Live connction mode.
As you mentioned, load your data into Azure SQL database then you can use Direct Query connection mode to connect to Azure SQL database.
Here is an offical blog about how to optmize Direct Query model.
For reference:
Optimization guide for Power BI
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help 😉
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,Rico Zhou
Hi, your answer was clear and efficient, thank you ;-).