Forum Discussion
09avinash
2 years agoFrequent Visitor
Power bi
I am unable to import sql server data to my powerbi desktop.my datasets is too large.what should I do for that
09avinash
2 years agoFrequent Visitor
I already did which you replied me.
The problem is that the data is too large after creating views and filter the column its take too many time to import in power bi desktop and finally return with error with timeout.
Idrissshatila
2 years agoSuper User
Then try direct query connection,https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- 09avinash2 years agoFrequent Visitor
No i have to use import mode.because i have to make lots of measures. Calculate column so i can't use direct query