Forum Discussion
Connecting Power BI to SQL Server with larger data
Hi Everyone,
Greetings,
I have connected Power BI to SQL Server table with larger data (4000000) rows as my data size is larger connected to power bi using direct query mode and crated the report now when i am selecting dates in date slicer data loading of visuals is taking time (45 to 60 seconds).
perfomace optiomization can i perform on the report or is it possible to use IMPORT mode instead of direct query mode...?
Regards
1 Reply
I don't think it is a good idea to move to import mode when you have huge data.
You need to explore other factors like query folding, DAX & query optimization, performance analyser etc.
Some reference material for performance tuning in Direct Query:
Simple DirectQuery Performance Tips – Insight Quest (insightsquest.com)
A comprehensive guide to Power BI performance tuning - SQLGene Training
