Confusion of the dataset size limit for a refresh in powerbi service with Pro

[chrisnewman]

I need to try and get to the bottom of something that should be very simple but the PowerBI documentation is extremely hard to understand. I can’t get much further until I have this sorted…

I’ve been advised to try and use import rather than direct query.  I’ve therefore built a pbix file with a sample local SQL database to keep it below the 1GB limit to be able to Publish.  This works fine.  When it is in powerbi.com it is then looking at the full off premises SQL database through a gateway.  When it then tries to refresh it fails as its above 1GB. I thought I should be able to refresh up to a 10GB dataset as per the link if I have the correct resource?  https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Thanks in advance

[KBO]

Hi @chrisnewman ,

as you see in the documentation it depends on your capacity settings. 10GB is for A6 or P3 ;). (Premium Capacity (P); Embedded Capacity (A))

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[chrisnewman]

Thanks for coming back.  I'm expecting the size to be 1.3GB so I set the capacity to A4 and it failed saying it was above 1024MB...

[KBO]

HI @chrisnewman ,

have you set the capacity on a specific Workspace or on the hole tenant? May be it will work if you set this to a specific workspace. I'm not the capacity expert but thats what I would do :D.

Best Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous · Accepted solution]

Hi @chrisnewman ,

Is your License Pro or Premium? The capacity for Pro is 1GB and the Premium can refresh upto 12GB size.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is

Best Regards,
- Pavan M.

[chrisnewman]

Thanks Pavan. So to be clear, if my refreshed dataset in servive is 0.9GB I can pay $9 a month with a Pro and and Embedded. And I can have 10 of these or so, i.e. up to 10GB total.

If any single one is 1.1GB I have to pay around $5,000 a month to have Premium?

I'm not being facetious, I've literally beeing trying for months and going through every link I can find and you are being the most help I've come across!

Many thanks