Data Source Error - Microsoft SQL

[siva3012]

Hi, I am loading the data from Sql Server into PowerBI and this table "Invoice Interval Charge" is in Billion rows. I am getting an error as shown dig. Can anyone guide me with a solution ? 

 All other tables are not loading due to this particular table.

[v-shex-msft · Accepted solution]

Hi @siva3012,

Based on your screenshot, the issue is related to your database engine. Please increase the tempdb size to work through the issue or re-write a suitable query.

Reference link:

Configuration Best Practices for SQL Server Tempdb–Initial Sizing

How to: Change the tempdb file size

Regards,

Xiaoxin Sheng

[siva3012]

@v-shex-msft : Thank you for response. I have a small dout, I am connecting millions of rows in one table with many tables which is the same, and intially i have imported the data by connecting to the SQL Server database by IMPORT query. "The database is normally connected through Remote Desktop location". My Query is Since i load data through IMPORT, all the query which is applied in advance editor will impact in my system or in the remote server.  

[vanessafvg]

@siva3012 you have run out of space in your tempdb, are you applying a sort at all in your query?  .

[siva3012]

How to increase space in tempdb ? 

I have applied some sort and pivot operations in edit query.