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

[tomcypress]

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?

[v-henryk-mstf · Accepted solution]

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.