Size of PBI file

Power BI
1

Is there a difference btw creating calculated columns using DAX and creating custom column in power query in terms of the size of the final file?
Also difference btw performing union etc using DAX VS in power query in terms of final file size.
Also, Is 1GB too much for a pbi dataset? Refresh time seems to be fine, if I have premium license, the 1 GB limit per dataset won’t be an issue, right?

2

@Anu
you can read a comprehensive article for the difference between a measure and a calculated column. Whatever the transformation you can do in Power Query is always better than performing with DAX.

1GB is okay for a pbi dataset if it’s not taking a lot of time to refresh. With premium licensing, you wont be having issues with limit per dataset as it is 10GB per dataset.

Thanks.

1 Like
3

Is it enough to assign the workspace a premium capacity

4

@Anu
This article will help you in deciding whether you need premium or pro licensing:

https://powerbi.microsoft.com/en-us/blog/power-bi-pro-power-bi-premium-flexibility-to-choose-the-licensing-best-for-you-and-your-organization/

5

Hi @Anu, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!