Forum Discussion

Alankar's avatar
Alankar
Microsoft Employee
5 years ago
Solved

Hi All Unable to load data in power bi desktop. Loading data model shows for long hours.

I have try load only TOp 10 rows but not loading my data 

  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Alankar,

    Can you please share more detailed information about your scenario? It should help us clarify your scenario and test to troubleshoot.

    How to Get Your Question Answered Quickly  

    Any advanced operation(merge, cross table calculation, custom function, iterator) that applies in query editor? If that is the case, you can take a look at the following link to use the buffer functions to improve calculation performance:

    Nested functions and Table.Buffer() - Exceed

    Regards,

    Xiaoxin Sheng

3 Replies

  • Alankar , Datasource? error?

    Make sure you are on the latest version of power bi

    You are able to query the database on this system

     

    What error you are getting.

    Enable parallel data load and increase cache memory in options and setting -> Options

    • Alankar's avatar
      Alankar
      Microsoft Employee

      I got above screen for last one hour where i have load only Top 10 records

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Alankar,

    Can you please share more detailed information about your scenario? It should help us clarify your scenario and test to troubleshoot.

    How to Get Your Question Answered Quickly  

    Any advanced operation(merge, cross table calculation, custom function, iterator) that applies in query editor? If that is the case, you can take a look at the following link to use the buffer functions to improve calculation performance:

    Nested functions and Table.Buffer() - Exceed

    Regards,

    Xiaoxin Sheng