Nested data model from Panoply

[Jameswh91]

Hi, We're currently trialling new sodtware but the data is being pulled into nested tables. Is there a best way to remodel the data by mergiing tables?

Does anyone else use Panoply?

[v-jingzhang]

Hi @Jameswh91 

Do you use the following methods to connect to Panoply? It seems you can select multiple tables and bring them into Power BI. Then you can merge them just like when you connect to other data sources and merge tables. 

Power BI on BigQuery - Power BI (document360.io)

Power BI on Redshift - Power BI (document360.io)

How do you want to merge tables? What is the expected result like?

Best Regards,
Community Support Team _ Jing