Forum Discussion

joeparkinson's avatar
joeparkinson
Icon for Helper I rankHelper I
2 years ago

Dataverse Synapse Link Choice Column Names

Hey,   I've integrated dataverse into fabric using Synapse link to automatically bring in all the tables into Fabric. However, the choice columns in the dataverse only return the integer ID of the ...
Data Integration
data warehouse
joeparkinson's avatar
joeparkinson
Icon for Helper I rankHelper I
2 years ago

Thanks - whats frustrating about this though, is I can pull all the tables in powerquery with their string straight into fabric. If I use the synapse link, I need to write SQL queries for each table and column (we have 100s of tables), so its going to be a huge amount of work vs using a dataflow.

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi joeparkinson 

 

Apologies for the inconvenience that you are facing here.

I would request you to open up a support ticket to get support from our engineering team for your query.

Please go ahead and raise a support ticket to reach our support team: support-ticket 

Please provide the ticket number here as we can keep an eye on it.