Power Query ODBC connection

[RaveenaAV]

Hi everyone

How do I go about splitting a master data source into separate tables using Power Query, I get my data from MongoDB through ODBC Connection, all of my data comes through as one master sheet, I would like to separate them into different sheets and still have the connection active with data coming through into the separate sheets rather than to one single master sheet.Is it possible to achieve this within BI or do I have to alter this at the API end?

Thank you for your help in advance!

[Sahir_Maharaj · Accepted solution]

Hello @RaveenaAV, 

Yes - This can be done by creating queries that filter and shape the data according to your requirements.

The connection to the original data source will remain active, and each new table created will refresh according to the data source.

Hope this helps.

[RaveenaAV]

Thank you