Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi community,
I would like to connect power bi premium to a large volume database table with over than 300GB through Azure Analytics services.
Is there a limitation of size in this case? I saw that i can go throught 10 gb maximum in the workspace with 1 GB maximum per dataset.
In my case i will go with direct connecttion, what do you recommand?
Thank you in advance!
Regards
Solved! Go to Solution.
Hi, @Nour-pbi
Dataset size limit - There's a 1-GB limit for datasets stored in Shared capacities in the Power BI service. If you need larger datasets, you can use Power BI Premium
In a Premium capacity, Storage is set to 100 TB per capacity node.
Depending on the SKU, Power BI Premium supports uploading Power BI Desktop (.pbix) model files up to a maximum of 10 GB in size. When loaded, the model can then be published to a workspace assigned to a Premium capacity. The dataset can then be refreshed to up to 12 GB in size.
Please refer to the following links in the hopes of helping you.
What is Microsoft Power BI Premium? - Power BI | Microsoft Docs
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Large datasets in Power BI Premium - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Nour-pbi
Dataset size limit - There's a 1-GB limit for datasets stored in Shared capacities in the Power BI service. If you need larger datasets, you can use Power BI Premium
In a Premium capacity, Storage is set to 100 TB per capacity node.
Depending on the SKU, Power BI Premium supports uploading Power BI Desktop (.pbix) model files up to a maximum of 10 GB in size. When loaded, the model can then be published to a workspace assigned to a Premium capacity. The dataset can then be refreshed to up to 12 GB in size.
Please refer to the following links in the hopes of helping you.
What is Microsoft Power BI Premium? - Power BI | Microsoft Docs
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Large datasets in Power BI Premium - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Nour-pbi , Model size Limit is 400GB for premium and 100GB for PPU
refer: https://powerbi.microsoft.com/en-au/pricing/
Hello @amitchandak thank you for you response. I see that the Model size limit is 400GB, however Maximum storage (Governance and administration)is set to 100TB, what is the difference between Model size limit and Maximum storage?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |