We have a REST API that we use to connect to several endpoints.
The default name of all the tables is: REST.Jsondata. This causes issues in our Azure Gen2 datalake. It gives an error saying the table name is already in use by a table with a different ID.
I almost feel like there must be some really easy way to rename the table name before it lands in the Gen2 datalake but so far I haven’t been able to figure out how.
The workaround I use now is to use a QueryTable but that is not the nicest way to do it I guess.