Forum Discussion

sanjoyleo's avatar
sanjoyleo
Helper I
8 years ago

Power BI Performance

Hello All,   This would be the first time we are creating PBI reports for customer. I have provided the report page where 17 Tiles are there. Among them ther are 4 Slicer.   I have 4 Tables which...
Need Help
quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi sanjoyleo

 

I've experienced the same issues. When checkin on the SQL server profiler I saw that the query made by PowerBI were not optimized (and there is no way to change that apparently)

 

The best option I found for my self was to create views of my table only keeping needed columns and by filtering my view with the years of data needed (I don't need data from before 2013)

Then, i've imported the view to PowerBI and it importing them work A LOT better than DirectQuery

 

Quentin

  • sanjoyleo's avatar
    sanjoyleo
    Helper I
    8 years ago

    Thanks for your responce !

     

    I can't filter data at this time. Need all the data available in table. So looking for some expert comments if the page refresh time that I have at this time is normal or not in terms of my setting & Volumes ?