Forum Discussion

1question's avatar
1question
New Member
4 years ago

Stuck at loading data to model for mySQL

It was working perfectly fine. Then today it stuck with the following window. I left it for hours, but nothing happened. Please help.

Need Help

22 Replies

  • Kasaros's avatar
    Kasaros
    Regular Visitor
    4 years ago

    I facing the same problem right now, but in power bi desktop and csv folders.

    it still shown "Creating connection in model.." for hours, and I restarted computer many times.

    I think this is some bug after september updated.

  • pcp123's avatar
    pcp123
    Regular Visitor
    4 years ago

    I'm experiencing the same issue.  Any data source will not load to the model even if you manually enter data to create a new table.   

     

    I tried restarting, uninstalling, reinstalling (older and current versions and nothing worked.

    • TheoC's avatar
      TheoC
      Community Champion
      4 years ago

      Close down Power BI. Try logging in to your Gateway. Open Power Bi and sign-in. Then repeat Get Data process. Hope this works. 

      • pcp123's avatar
        pcp123
        Regular Visitor
        4 years ago

        Thanks for the suggestion but it didn't work. 

         

        I am curious, do folks helping on here work for Microsoft or are they just friendly strangers?

  • calimero48's avatar
    calimero48
    Helper II
    4 years ago

    Hi

     

    I have the same issue with power bi desktop (September 2021 and december 2021 version).

    The data source is an SQL server.

     

    Do we have a way to get the Power Bi version August 2021 to test if the issue exist?

     

    Or Does Microsoft release a fix?

     

    Thanks to all for your help

     

     

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    1question I'd recommend cancelling, shutting down your computer, restarting and seeing if it works. 

    • shareefb's avatar
      shareefb
      New Member
      4 years ago

      Is there any progress from microsoft in this annoying issue.

      I am also facing the same problem in a vm I am preparing, I tried downgradin, upgrading Power BI and even added new Memory to the VM machine. nothing is helping.

    • kymilue's avatar
      kymilue
      Frequent Visitor
      4 years ago

      Seeing the same issue, I have restarted, uninstalled, reinstalled, cleared cache. I've installed older versions of desktop as well, nothing is fixing the issue. 

  • sunil-al's avatar
    sunil-al
    Frequent Visitor
    4 years ago

    Same issue, stuck at "Creating Connection in Model"

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi 1question 

    Please check whether your Power BI Desktop is the latest version. The latest version should be 2.97.921.0 (9/28/2021)

    If it is not the latest verison, please update your desktop and try again.

    For reference: Download

    Or you can try to optimize your data model. 

    For reference: Optimization guide for Power BI

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi All,

      I'm facing this issue since last September, soon I downgraded to the August 2021 version as other users did, which solved the issue. But recently the "Loading to model" issue came back even with August 2021 version.

      I'd like to track how MS is fixing this issue, that is very limiting.

      Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I'm having the same problem.  I get to 1.68 GB loaded and it stops making any progress at this point.  I've tried everything on this board suggested.  It worked fine in December.  I only have half a million rows in the query and it is pulling data from dataflows that load and refresh fine.  Getting desperate....

    • kakigopinath's avatar
      kakigopinath
      New Member
      4 years ago

      got any solution for that.....?

      i yes please share your solution...

      tryed august version, re booted pc, re installed...

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I never figured out what was causing the problem unfortunately.  I reverted my .pbix file back to an earlier version from a few months prior.  Luckily I hadn't made too many changes to it in those months so I made all the changes again to the old file and performed a refresh and it started working.  After this experience, I now keep quite a few "backup" versions so that if this ever happens again, I can go back to the one prior that refreshed fine.  Pain in the arse but don't see any way to get around the issue of it just refusing to finish a refresh.  

  • kakigopinath's avatar
    kakigopinath
    New Member
    4 years ago

    got any solution for that.....?

    i yes please share your solution...

    tryed august version, re booted pc, re installed...

    • calimero48's avatar
      calimero48
      Helper II
      4 years ago

      Hi

       

      I have tested with the version of februray 2022. The problem has gone away.

       

      Best regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi,

        Glad to know that it worked for you. I haven't the same luck.

        Can I ask you what are s the settings related to data loading, in your PBI Desktop options windows? I wonder if those settings can make it work, or not.

         

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I accidentally stumbled across a fix for my problem. My Power Query was a Web.contents() Get api request and it simply could not get past the Enable Load into model and I was getting the same in progress timer indefinitely.

    It turns out, the API response was returning a nested json which is equivalent to table of tables and I think each table, however small, is loaded by a thread. 

     

    Fix for me was to navigate under home file menu Option & Settings -> Global Options and set the Maximum Number of Simultaneous Evaluations to more than 1 (which it was by default)