Forum Discussion
Dataflow gen2 does not work with 'optional' as a column name!?
Funny indeed, and not mentioned anywhere in the documentation. Who knows what else is reserved.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .Thank you for raising this issue! The team has confirmed that this is a bug and are currently working on a fix.
Will update this thread once there's a timeline that I can share for the fix.
In the meantime, the only alternative is to not use the keyword "optional" in your columns or queries.
Thank you for raising this issue! The team has confirmed that this is a bug and are currently working on a fix.
Will update this thread once there's a timeline that I can share for the fix.
In the meantime, the only alternative is to not use the keyword "optional" in your columns or queries.