How to analyze datasets over 2GB on powerbi report server?

tomcypress — Thu, 01 Sep 2022 08:58:20 GMT

In order to get enough report analysis performance, I imported all the data into PowerBI, but the size of the dataset exceeds 2GB and I cannot upload it to PowerBI report server. I have tried the scheme of calling the restfulAPI interface but didn't find a solution. Is there any way to analyze data over 2GB in PowerBI report server?

Re: How to analyze datasets over 2GB on powerbi report server?

v-henryk-mstf — Fri, 02 Sep 2022 06:32:14 GMT

Hi tomcypress ,

It is recommended that you consider using the Vertipaq Analyzer tool to help you reduce the size of your model.

Quickly review your Power BI Data model with VertiPaq Analyzer - Guy in a Cube

Or you can deploy the model to an Analysis Services table instance and connect the pbix report to this instance in live connection mode, which can exceed the 2GB size limit.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: How to analyze datasets over 2GB on powerbi report server? in Report Server

How to analyze datasets over 2GB on powerbi report server?

Re: How to analyze datasets over 2GB on powerbi report server?