Forum Discussion

phcampbell01's avatar
phcampbell01
Frequent Visitor
4 years ago

Dynamics Combining of Tables

Hi All,   Building dataflows and want to be make the model as re-usable as possibe. I am trying to, if possible, build a merge table from a list of other tables but do dynamically.   So in the da...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi phcampbell01 

 

It seems Power Query in dataflow doesn't support keywords that well like in desktop. You could refer to this blog: Get List of Queries in Power BI - RADACAD. In comment area, Reza Rad says that "This method only works inside the Power Query Editor. the environments of #shared and #sections are not available when you load data into Power BI." Based on my test, I can combine queries well in Power BI Desktop while only get null for each table in dataflow. 

 

Best Regards,
Community Support Team _ Jing

phcampbell01's avatar
phcampbell01
Frequent Visitor
4 years ago

Thanks for that, thats what i had determined as well.

 

I looked at the article you mentioned and noted Reza says "Unfortunately, there is no way to append query names like that when you load data into Power BI unless you statically have their names somewhere."

 

To his last point i could have a static list of the tables ( {"ClientsTable1","ClientsTable2",ClientsTable3"). On this basis could i form a statement to combine the related tables?

 

Regards