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

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
1 year ago

thilokg 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