Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data load doesn`t work after expanding a Record

Hi, 

 

I have a date set with reference to a Record. 

I expand the Record to one field only - [fullname]

 

But once Record is expanded, data load takes forever.

It is couple kb per sec. After half an hour is is  approx 2MB, but I have never waited until it finishes. 

 

Any idea on what causes this and how to solve it? 

 

Thank you! 

Need Help

6 Replies

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous  try unchecking this and let me know if it improves

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    PhilipTreacy smpa01 iXpert_info 

    Thank you for the comments, but none of it helps.

     

    This problem is directly related to the expansion of the Record: 

    -> data size, internet speed, query, etc is not the fault here;

    -> only one column is loaded from the Record;

    -> the same query loads just fine when the step "expand record" is removed;

     

    Is there any technical difference between data type "Record" and "Table"? Because when expanding data type "Table" there is no such an issue! 

    • PhilipTreacy's avatar
      PhilipTreacy
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous 

      Yes, a Table and a Record are different data structures, but that in itself doesn't indicate why you are having this issue.  It's just as possible that expanding a table can cause this type of problem.  It depends no what data is in the data strcture and what you do with it after expanding it.

      So the record createdby only contains 1 field?  There's no other data in that Record? 

      And your data Source is Dynamics CRM?

      What happens if you remove all columns except the Record and then just expand that?

      Regards

      Phil

    • iXpert_info's avatar
      iXpert_info
      Icon for Helper II rankHelper II
      5 years ago

      Hey Anonymous 

      Just check if this tool can help you 
      https://www.xrmtoolbox.com/
      After you download that plugin you just need to download power query builder plugin.

      Did I answer your question? Please mark this as solution to help others

      Best Regards
      Jay Patel
      iXpert Analytics

  • iXpert_info's avatar
    iXpert_info
    Icon for Helper II rankHelper II
    5 years ago

    Hey Anonymous 

    When you expand that record only select the columns you need. this way it will load only limited columns. 
    When you will select on below highlighted button shown below it will show you to expand only selected columns

     

    Did I answer your question? Please mark this as solution

    Best Regards
    Jay Patel
    iXpert Analytics

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

    How much data/how many rows are you trying to load?  Maybe it's just the sheer size of the data your're trying to pull in.

    What data is in the Record?

    What other transformations are you doing?  WHat does your full query look like?

    How fast is your internet connection?  Loading 2MB after 30 minutes seems very slow.

    Regards

    Phil