Turn a report table into a dynamic table in the model

[johnmelbourne]

I have a table in a report as per below. The columns come from a variety of tables. I now want to turn that table in the report view into a dynamic table in the model. Is this possible?

Or should I just export the table as a .csv and reminport back intop the model as a new table. I would prefer not to do this as it is not dynamic.

Thanks

John

[TeigeGao · Accepted solution]

Hi @johnmelbourne ,

If the columns comes from multiple table and you want to merge them in a table, it is possible in PowerQuery, we cna use Table.Join() function to join these tables: https://docs.microsoft.com/en-us/powerquery-m/table-join, but the data imported into a model is stable, it is not possible to create a dynamic model.

Best Regards,

Teige

[johnmelbourne]

Thanks for taking the time to share your answer.

Regards

John