File too big to import from online source- (500): Internal Server Error.... any solutions?

[Anonymous]

Hi,

So I'm importing data tables into power bi from an online source and It was going fine until I got to a particularly large table. When I try to import it after a while I get this error (500): Internal Server Error message. 

Does anyone know how I can fix this, for example, is there a way to lengthen the amount of time Power BI will try and download something?

Thanks!

Cambell

[v-yuezhe-msft]

Hi @Anonymous,

What online source do you connect to? Do you use Power BI Service or Power BI Desktop to connect to the data source?

Thanks,
Lydia Zhang

[Anonymous]

Hi @v-yuezhe-msft

Its an online database that has been created by the company I work for and I connect to it by creating a blank query then typing into the advancced editor some code I was sent to use and I just modify slightly to import different tables (I'm not sure if I'm allowed to post it here sorry). It uses Json data. Should I try linking to it in another way?

Best wishes,

Cambell 

[v-yuezhe-msft · Accepted solution]

Hi @Anonymous,

There are some proposals for you in this scenario.

1. Reduce the columns and rows you import to Power BI Desktop, in other words, only import records of the large table your need to Power BI.
2. Check that if you can add CommandTimeout parameter which is discussed in this similar thread.
3. Use 64 bit version of Power BI Desktop.
4. If the error still occurs after performing the above steps, consider to export data from this large table to SQL Server database, then use DirectQuery mode in Power BI Desktop to connect to the SQL database.

Thanks,
Lydia Zhang