Forum Discussion
POWER BI to KDB+ database
Hello,
Can anyone help me I connected the PowerBI desktop to the KDB+ database using the Simba ODBC connector.
I have a table with 7 million data when I try to load it to power BI it takes 30 min, I am a little bit concerned here if 7 million rows take 30 mins, what about a table that I have with 10 billion rows is there any way to load these tables faster? kindly guide me.
Anonymous
Check the solution in this post, this is the best answers your question. importing enormous data into power bi is really not a good option.
Solved: Connect to SQL data source with 1 billion rows of ... - Microsoft Power BI CommunityPaul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , In Option and setting ,
Increase cache size and try following under data load
Anonymous
Check the solution in this post, this is the best answers your question. importing enormous data into power bi is really not a good option.
Solved: Connect to SQL data source with 1 billion rows of ... - Microsoft Power BI CommunityPaul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
