Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to add an imported date column during the Power Query step of my dataflow. I have an inserted timestamp for the source, however that timestamp can change. I am trying to utilize the incremental refresh capabilities of Dataflows and advice from Microsoft is that if one wants to use the (Detect Max Data Changes) option, I would need a DateTime column that would not change.
This led to me trying to create the DateTime column in Power Query. I cannot use DAX since DAX is not allowed at this step of the Dataflow process.
I tried adding a custom column (seen below) but am getting this error:
Solved! Go to Solution.
It's close. It needs an "each" before DateTime.LocalNow
Did you type this in the advanced editor? If you use the 'Add Column' in the interface, it adds it for you
It's close. It needs an "each" before DateTime.LocalNow
Did you type this in the advanced editor? If you use the 'Add Column' in the interface, it adds it for you
Thank you @HotChilli it worked.
To your later question, yes I started with adding a conditional column then edited it in the advanced editor. I was unable to find the add new column in the interface. could you point me to where it is?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.