Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply

Dynamic Table Combine - For External Sources

Hello, 

 

Hope someone can help with this soluton; 

 

So I have a dynamic list of Completed Financial year sales data table refferences that I'd like to feed Table.Combine. 

 

WillBatesHydro_1-1674146122159.png

 

 

I also have another list that refferences the previous to create a bit of M code that pulls in a table from a workbook stored in Sharepoint. 

WillBatesHydro_2-1674146271069.png

 

If you copy the text from any row and paste it directly into a new query it works.  

WillBatesHydro_3-1674146346891.png

 

If you copy each line of code and paste it into a table.Combine query for each itteration it works

WillBatesHydro_4-1674146447940.png

 

 

 

 

 

So the question is, how would I use the list of M codes as opposed to hard coding the code as shown in the above? 

 

 

Would really appricate your response! 🙂

 

Thanks 

 

Will 

 

 

0 REPLIES 0

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.