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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Lorenz33 I think everyone missed a point. Let me start:

 

- there is nothing like Power BI Desktop Premium. Premium is a capacity which you use and is only applicable in Power BI Service

 

- Why I mention the above point since you are using Power BI Report Server (On-Prem), Power BI Premium is not even in the picture.

 

- I don't have much experience with Power BI Report server so I cannot comment on it

 

- I worked with a very large database (it is not necessarily you can always aggregate the data) but I have worked with a dataset with a size of 300 ~ 400 million rows, with full optimization and filtering/aggregation where possible

 

- Using such a large dataset was possible in Power BI Premium and the performance was lightning fast since the model is fully optimized.

 

So for your question on Power BI Premium is not in the picture since you are using an on-prem Report Server, how does it work and what can be done there to work with large volume, sorry I'm not the right person but anything outside report server, I will be more than happy to assist.

 

Cheers,

 

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).