Forum Discussion

lightknight's avatar
lightknight
New Member
2 years ago
Solved

Improve performance Power BI desktop for report server

Hi everybody, I have a huge dataset coming from mobile in-app events tracking and my company deploys Power BI Report Server (ver. Jan 2023) to visualize the data. Data is fetched daily and stored in...
Data model
Power BI Desktop for Report Server
Storage mode
  • lbendlin's avatar
    lbendlin
    2 years ago

     

     

    Data volumn grows expotentially (1 million rows appended each day)

     

     

    No need to embellish this - you can call it a linear growth if it is one.

     

    Keep track of the queries issued by your report server against your SQL data source, and optimize your database for these queries.  Make sure indexes and statistics are updated after each substantial insert.

     

    Consider loading your data into an SSAS cube or a SSAS Tabular instance, and accessing it via live connection. That way you can emulate the incremental refresh feature of the Power BI service.

lbendlin's avatar
lbendlin
Super User
2 years ago

 

 

Data volumn grows expotentially (1 million rows appended each day)

 

 

No need to embellish this - you can call it a linear growth if it is one.

 

Keep track of the queries issued by your report server against your SQL data source, and optimize your database for these queries.  Make sure indexes and statistics are updated after each substantial insert.

 

Consider loading your data into an SSAS cube or a SSAS Tabular instance, and accessing it via live connection. That way you can emulate the incremental refresh feature of the Power BI service.