Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Managing GUID columns in a PBI data model

Hi, in order to rationalize the columns for the tables of a PBI data model, how is better managing GUID columns? For fact tables it's good to avoid to have these key columns in the model, but for d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

I'm searching the best practice to manage GUID columns read from a data source in order to reduce the occupied space in memory.

Think about a GUID column with more and more distinct values.

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

Current I haven't found any effective solution to cutdown the cost of guid.

 

Maybe you can try to use identity column to achieve unique id.

 

Regards,

Xiaoxin Sheng