Linked entity not retaining primary key or currency data type

[hndodds]

I'm trying to set up a series of dataflows A > B to process some structured data (SQL database source).

Query A is just an extract, and the service correctly types the data and marks the key.

Query B includes a linked entity from Query A, which is referenced and then used to rename the columns, add flags. The linked entity does not retain the data type Currency, or the key.

I know that schema view is a preview feature, and I'm hoping the issue with keys will be resolved eventually, but the data type change seems like a bug. Has anyone else had this happen?

[hndodds]

I've let it refresh several times and the key is not retained, the datay type currency is not retained. I am using the connector for PowerPlatform Dataflows if that makes any difference.

[v-cgao-msft]

Hi @hndodds ,

Try refreshing the upstream data stream after it is the downstream data stream whether the build and data type can be changed back.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data