Forum Discussion

Lorenz33's avatar
Lorenz33
Icon for Helper IV rankHelper IV
4 years ago

Power BI Desktop and large data volume

We are creating a Power BI report (hosted on premises on Power BI Report Server). This report contains a table that retrieves the data from a fact table in a relational SQL Server database. The numbe...
Need Help
Lorenz33's avatar
Lorenz33
Icon for Helper IV rankHelper IV
4 years ago

Thank you for your advice. I currently have a Power BI Pro license. If I get a Power BI Premium license (per user), I should be able to create and upload the report with more than 1 million rows right? Will users with the Power BI Pro license still be able to access all of the data in the report? In other words is it only required that the report creator has Power BI Premium in order to create all the report with the more than 1 million rows?

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

If you create a report in a PPU workspace, then only other people with a PPU license can view it.

 

Please re-read the other answers though. You should be able to work with datasets containing many millions of rows without running into this DirectQuery limit since this limit is not the dataset size but rather the number of rows returned in a single query. If you have a DirectQuery returning more than 1 million rows for a particular visual, then something is likely bad with the model or measure (whether you have premium or not).