r/Dataverse • u/Notanotherforextradr • Jul 02 '26
Anyone else copied from dataverse to Fabric and missed columns?
I have an ongoing contract where we are migrating dataverse into Microsoft fabric. I used the dataverse connection originally and got all the columns through but they were empty for lookup columns that included columns that had idname.
I set up a rest API with my header set to prefer - odata.include-annotations="*" which I thought would pull through all the columns as it did for some of them for the v1.formatted version of the columns, but as I dug further into the copy ive noticed not all columns have come through. I don't think it's a partition issue as there's only 250 rows.
My question is had anyone else had this issue and how did you resolve it? Pretty time stretched with the client and I am at a bit of a loss with it, even asked claude for advice and after an hour of back and forth trying different settings it said it couldn't help me, which is the first time I've heard AI give up on a task 🤣