Forum Discussion
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
5 Replies
Hello 09avinash ,
Try creating views that with dimension and fact tables, where you alsoget only the columns you need and you may filter the data to get what is required for the analysis, not just take everything into power bi.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea 💡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.
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 👍
