Forum Discussion
Expanding three Quickvbase tables in one query
Hi there
I am pulling in a QuickBase app using the QuickBase connector in Power BI Desktop.
The QuickBase URL shows me three tables that I need to expand. All three hold the same column names, just different year data.
I can expand all three separately, then Append, but is there a clever way I can expand them all in one query?
Jemma
3 Replies
- mahoneypat
Microsoft Employee
Do you see the three tables in different rows of same column (prior to expand)? Or in three separate columns? If the former, just expand that column. If the latter, you can unpivot the columns with the tables, and then expand. If neither applies, please add a screen grab of the view where you see the three tables.
Pat
Hi mahoneypat
The tables are in one column, different rows, but there is no expand option just links. So, at the moment I run the same query three times so I can expand all three tables. Here is a screenshot with the three tables I care about highlighted.
- mahoneypat
Do you know what format the content in the ItemName link are stored in (probably JSON)? If you click to the right of the link inside the cell, can you preview it? If you click on the link, what function does the query editor choose to open it in the navigation step? You should be able to drill down on one of them, expand/transform it, and conver that M code to a function that you can invoke in a custom column. You would then have a column of Tables that you could expand. If it is JSON, you can make a custom column with Json.Document([Data]) and go from there.
Pat
