Publish Power BI report with maximum size

Question

I want to add reports into the Power Bi that is connected to dynamic 365 and the reports have data more than 2GB, and cannot able to publish the reports. Is there any way to decrease the size of the dataset so that we can refresh the data and get 2gb of data

Answer 1

 

• Delete the unnecessary Columns 
• Delete unnecessary Rows
• Group and summarize<aggregate data
• Optimize the column data < close the right data type for each column
• Custom Column < Create a Custom Column
• Disable Power Query
• Disable auto date time
• Switch to the mixed-mode

Intellipaat also provides Power BI Online Course, Enroll now!

If u want to know more about Power BI and how to become a Power BI professional, then check the Power BI Developer blog