loading huge data

[RIDWIV]

Hello all,

I am trying to load 80 crore data from my SQL database to powerbi. But unable to load. Even i set the time limit then also. Showing below error. Any method how to load.

[ppm1]

How many rows and columns of data are you trying to load? This article may be useful.

How Much Data Can You Load Into Power BI? - Chris Webb's BI Blog (crossjoin.co.uk)

Also, you can leverage incremental refresh to break up the work. See this playlist by Guy in a Cube, especially the one about "Avoiding the full refresh ...".

Everything you wanted to know about Incremental Refresh in Power BI - YouTube

Pat

Pat

[RIDWIV]

there are total 10 rows and columns I am unable to count