Gilbert Quevauvilliers needs a key:
When I started looking into using the data warehouses feature in Fabric, I did see that there were limitations on Primary Key columns.
Below is my blog post on how I still use keys in my data warehouse, instead of using GUID’s which to me are long and hard to use.
In my example I am going to create a simple data warehouse which is going to consist of two-dimension tables (Date and Country) and a fact table with the Sales amounts.
This seems sub-optimal, though at least Gilbert shows us a workaround.