Publish Power BI report with maximum size

[asimsajjad]

I have Power BI report which is connected to the dynamic 365 to show the report of contact and account but the data set has more then 2 GB of data and I am not able to publish the report. how can I decrease the size of the data set so that when publish I can refresh and update data set to get the 2 GB of data.

I am not able to publish the report one thing which I used to take the top 100 rows by using one of the option in the Data Set but when I refresh the data set after publish it get top 100 record

[V-pazhen-msft]

@asimsajjad 

Take a look at this video.

https://guyinacube.com/2019/08/22/2-ways-to-reduce-your-power-bi-dataset-size/ 

Paul Zheng

[GilbertQ]

Hi there

You either have to reduce the amount of rows.

Or have a look at all the columns and see which ones are not needed.

Typically the columns that have got GUID's or values that are unique to every row on a table will take up a lot of space.

Also if you look to create a star schema in your dataset and use key columns to create the relationships between the tables you can save a lot of space, as well as make the measures run faster.