We are using an OData connector to try and extract multiple tables from a SAP HANA environment in Microsoft Fabric Dataflow Gen2. Currently we are extracting these tables one by one with separate queries. This is a pain-staking manual process and prone to errors.
It is possible to retrieve a list of tables from the OData connector, but we currently cannot loop over the list of tables because we need to define separate queries in order to get separate tables in our lakehouse.
Is there any way to save multiple tables with a single power query? Or alternatively, is there any way to easily create multiple queries based on predefined data.
1