Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello folks,
I need to create a composite key column by combining several columns:
However, I get the following error message:
"DataSource.Error: Microsoft SQL: Conversion failed when converting the varchar value '|' to data type int."
I suppose the reason for this is because some of the columns are of a type int and some are of a type text and those that are of type int need to be converted to text. However, for the purpose of query folding, I'm not allowed to change the column type (or at least this is what the documentation says). Is there any workaround for this?
Solved! Go to Solution.
You can wrap the non-text columns with Text.From in your expression. If that won't fold, you could always make your column with a DAX expression after the table is loaded.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can wrap the non-text columns with Text.From in your expression. If that won't fold, you could always make your column with a DAX expression after the table is loaded.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.