cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jciromil Frequent Visitor
Frequent Visitor

Support for billion of rows in Power BI

Hello Team,

 

I have a database in Azure table storage that has 1.5 billion of rows and I want to built several reports and dashboards out of that data. My questions are as follows.

 

  1. Does Power BI support huge datasets? If so, what is the best practice to set up dataset
  2. While importing huge datasets, do we have to use import mode or direct query? For a sample purpose, I was able to import huge database that had 10 millions records nto P-BI which took 1 hour (which btw is not an ideal story)
  3.  Say if Power BI supports huge records, how to maintain performance of the reports?

P.S.  I have found one article that says P-BI supports 1 trillion of rows and a video that showcases the huge count but not sure how it would work if importing 10 mill of records took 1 hour.

 

Link to video: Link to article

1 REPLY 1
Community Support Team
Community Support Team

Re: Support for billion of rows in Power BI

Hi @jciromil ,

Based on my research, Power BI could support huge dataset, but I suggest you ues direct query or live connection considering performence, you could refer to below blog:

http://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.