Not able to publish more than 1GB power bi file to on premise Report Server

[Anonymous]

Hi,

I am posting this again in the community and expecting to get answer from you guys,

I am not able to publish more than 1GB  power bi file  to Report Server it's giving error file too large.what should i do to upload it.should i upgrade power bi desktop license to premium per user or is there any workaround for that.

I would highly appreciate if some guide me about power bi desktop and report server licensing.both are same or diffrent.


Thanks

[Anonymous]

Thanks @selimovd  and @ribisht17 for helping me out.
@selimovd  I will check and let you know in case of any issue or if i need any further help.

[ribisht17]

@Anonymous 

Check this as well 🙂 Try limiting rows when creating reporting for big data in Power BI - YouTube

Regards,

Ritesh

[Anonymous]

Sure @ribisht17 i will look into that.Thanks alot.

[selimovd · Accepted solution]

Hey @Anonymous ,

the limit in Power BI Report Server is 2 GB.

But you have to raise it in the settings. Check the following article on how to do that:

https://docs.microsoft.com/archive/blogs/sqlrsteamblog/setting-a-maximum-file-size-in-sql-server-2016-reporting-services

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[ribisht17]

@Anonymous 

1: >>>

"The standard limitation on the dataset size cached in Power BI is 1 GB. But with Power BI Premium, we will be removing that limitation. You will be able to build models as large as the Power BI Premium dedicated capacity memory can hold. This means that the Power BI Premium P3 SKU will be able to support a dataset with 50 GB of data or more, and upcoming SKUs will offer capacity sizes that allow datasets with hundreds of gigabytes of data"

2>> 

You will need to switch to DirectQuery.

3>>

Reduce your data-model size if possible

I don't see any other option here

Regards,

Ritesh

>>How to Publish Files Greater Than 1 GB - Microsoft Power BI Community