Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous

       

      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 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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