topic Re: PowerBI dataset size memory issue in Developer

PowerBI dataset size memory issue

Anonymous — Mon, 28 Nov 2022 10:59:44 GMT

I am trying to store around 1 million records using PoweBI API

endpoint - /v1.0/myorg/groups/{groupid}/datasets/{datasetid}/tables/{TableName}/rows

csv file which is containing whole data is of around 89 MB, but when it is inserting records it becomes more then 1 GB.

And power bi returns data size error and do not insert further data, and same data when i am processing again in different dataset it fits into 51MB space.

I want to know insights how power bi is processing data.

Note: workspace is same for both datasets.

Thanks!

Re: PowerBI dataset size memory issue

Anonymous — Tue, 29 Nov 2022 09:23:46 GMT

Hi @Anonymous ,

Firstly, which are your current license in Power BI, free/pro/premium?

There's a 1-GB limit per dataset that is imported into Power BI, unless the workspace is in a Power BI Premium capacity. See the Large datasets section of What is Power BI Premium?

For reference: What is Microsoft Power BI Premium? - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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