Forum Discussion

thilokg's avatar
thilokg
Frequent Visitor
8 years ago
Solved

Power BI Desktop - IMPORT data limitation

When I use Power BI Import (Connect to SQL Server and select Import) to get data to Power BI Desktop, is there a data volume limitation?  I know for DirectQuery there is no data volume limitation. W...
Need Help
  • zoloturu's avatar
    zoloturu
    8 years ago

    Hi thilokg,

     

    There is no volume limitation for a load for either DirectQuery or Import. DirectQuery has a limit of rows behind each visual - 1 mln, but Import has no such limit. You have a limit for Import mode - memory usage limited to your computer resources (RAM). So if you have 8 GB of RAM and your report consumes 9 GB then it will fail. You can check usage via Windows Task Manager -> Resource Monitor (https://www.digitalcitizen.life/how-use-resource-monitor-windows-7)

     

    Regards,

    Ruslan

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Hi thilokg,

 

There is no volume limitation for a load for either DirectQuery or Import. DirectQuery has a limit of rows behind each visual - 1 mln, but Import has no such limit. You have a limit for Import mode - memory usage limited to your computer resources (RAM). So if you have 8 GB of RAM and your report consumes 9 GB then it will fail. You can check usage via Windows Task Manager -> Resource Monitor (https://www.digitalcitizen.life/how-use-resource-monitor-windows-7)

 

Regards,

Ruslan

Element115's avatar
Element115
Memorable Member
1 year ago

zoloturu  What you say is true on a local PC running Power BI Desktop app.  But that does not apply to the report and its semantic model once you publish it to the Fabric Service. Once published, the following constraint applies.

 

In Import mode, the total size of your semantic model is limited by your licence type.  So, under a Pro licence, you only get a maximum of 1 GB after you publish the report to the Power BI Fabric Service.  

 

However, if you upgrate to a PPU (Premium-per-user) license, the max amount for storage of your model jumps to 100 GB.

 

Pro -> 1 GB

PPU/Premium -> 100 GB