Forum Discussion

SMiddel's avatar
SMiddel
Copper Contributor
Nov 20, 2019

Get&Transform / Power Query stuck on load to Data Model

Hi all,   I have been working with Power Query / Get&Transform for several years now, and have now run into a problem I have never encountered before. What I am trying to do is load a new query to ...
BI & Data Analysis
developer
excel
power bi
JPadrino's avatar
JPadrino
Copper Contributor
Apr 16, 2020

SMiddel 

This remains an issue. I have been using Get & Transform (Power Query) for several months to update price book data in SFDC, but today I started getting this load issue when trying to merge 2 queries. It simply starts loading millions of rows from an external source (or so the text notification says). Has there been any movement on finding a solution? This has been an issue for over a year I believe.

  • SMiddel's avatar
    SMiddel
    Copper Contributor
    Apr 20, 2020

    Hi JPadrino

     

    For me the issue i described was fixed at the beginning of February with Version 1912 (Build 12325.20344). Please see https://social.technet.microsoft.com/Forums/en-US/aaf4823f-954d-400b-bde0-858639a475f4/power-query-load-to-data-model-constantly-stuckhanging?forum=powerquery&prof=required for more details. Not sure if your issue is the same as mine to be honest.

     

    Kind Regards,

     

    Stephan

    • JPadrino's avatar
      JPadrino
      Copper Contributor
      Apr 20, 2020

      Hi Stephan,

       

      I'm not sure this is the same issue that I am having, but I will work through the suggestions to see if anything works. Thank you for forwarding the info.

       

      Jim 

Resources