Forum Discussion

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Power Query "looping"

Hi all,   I am trying to build a custom PQ connector for a data source that provides a number of data tables and related dimensions. Ideally I would like the user to enter the name of the table to ...
Need Help
jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

thanks, interesting... do you have sample of the tables involved with data / pictures?

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
9 years ago

sample is in there: Just click on step "AllocationTable" and the content is there:

Do you need samples for the other tables as well?

 

 

 

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Wanted to report back that Imke has helped me resolve this. In the end we needed to do a Unpivot and Pivot operation.