Dataflow dont save comments outside let statement

[Anonymous]

Hello everyone,

I cannot save the comments in dataflows above let statement. For example:

-------------------------------------------------

/***

  Query Name: Query A

  Creation Date: 2022-11-23

  Author: XXXX

  Purpose: ABC

***/

let

  Source = Sql.Database(XXXXX),

  Navigation = XXXX
in
 Navigation
--------------------------------------------------

Everything inside the let statements seems to be save. But everything outside the let statement is not saved after closing the dataflow. In Power Query in Power BI Desktop same approach does work smoothly, I need this for the documentation purpose.

Is it a bug, or do I need adjust some settings inside of dataflow?

[BA_Pete]

Hi @Anonymous ,

I've just tested and can confirm that Dataflows do NOT save either block or line comments above the 'let' or below the 'in' step.

I doubt MS would see this as a bug TBH. Code comments are for commenting code, not really for broader documentation.

You can always use the Properties functions either on the Dataflow as a whole (click the ellipsis next to the DF name in your workspace), or on each individual query within the DF (right-click the query in your DF).

Pete

[Anonymous · Accepted solution]

Thank you Pete, 

it one of the workarounds, we decided for the time being we just add the general code comment right after the let line.

Also I committed new post in the “Ideas” section, will see what will happen.