Forum Discussion

deepakumar's avatar
deepakumar
New Member
8 years ago

Handling Large Data Sets

Hello! I am pretty new to Power BI and I am looking for advice on best practices. We are attempting to use Power BI to report our largest set of data which is around 60 GB and it's hosted in azure SQ...
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi deepakumar,

 

There is 1 GB dataset limitation for Import mode(If this limitation is hit, the report cannot be published to Power BI service). However, the 1 GB dataset limitation does not apply to DirectQuery. So you may need to use DirectQuery in your scenario. 

 

In addition, filtering rows option in Power Query or importing Data from Database using Native Database Query can also be used to limit the data used in Power BI. :smileyhappy:

 

Regards