Forum Discussion
Lorenz33
Helper IV
4 years agoPower 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...
smpa01
Community Champion
4 years agoI have queried, modeled, viz'd in PBI with SQL table currently at 63M+.
It is possible that you don't need to bring the whole granualr table for analysis. In that case, you can easily do some server-side filtering /transformation/aggregation and bring the aggrgated data, which will dramatically cut down the size.
Should you need the whole granualr table (probably not if you deep dive), you have premium workspace, you can take advantage of the dataflow ,incremental refresh and qery and store the result in dataflow and build report by querying dataflow. Make sure the SQL filtering and transformations are optimized else the dataflow will time out.