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 ...
Need Help
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