Thanks, Reid. Great tips! I had never thought to use the Query View for notes. I will try this! I typically maintain a revision history table in Power Query to log a summary of changes of a published report.
That could work too! Tools like Git integration, or software like PowerOps does make it easy to also compare versions as well between files (expanded beyond just Power Query).
When doing multi-line notes the block syntax is worth mentioning /* */, or just type a bunch of text, select it and hit Ctrl + / (on a UK keyboard) to toggle comments.
as from my experience: user can't see the descriptions in viewer-mode on powerbi service, right? is there a way that they can access the notes? This notes can be helpful if they want to personalize a visual.
Anyone with build permissions who could do self-service reporting can see the descriptions when hovering over the fields. For people just looking at the report. They wouldn't want to look at the fields list. If you need extra notes for them. The visual header Help tooltip is my recommendation, adds a custom tooltip description, per visual/object on the report page :) prologika.com/power-bi-visual-help-tooltips/
Nice:) Just a pity there are no better ways than these workarounds. I think for example, that if you publish the report with the bookmarks, the users can see them as well. MSFT should come with better ways.
I agree on better location for notes. For bookmarks though, users do have access to the bookmarks pane in reader mode once published. They just don't use it often, but they can see a list of all report bookmarks the developer built :)
I agree, but would I like a mid-point. I would like to hide bookmarks that are being used by devs to add report functionality, but also create 'global' filter type bookmarks that all users can access instead of them all needing to setup or try to share personal bookmarks.
@@workstuff5253 it would be nice to hide bookmarks entirely! I find that using the Bookmark folder can help with that at least. Having top level folders like "Report Users" and "Developers Only" at least separates them and lets people know which are the bookmarks for them to use. Not perfect, but better than not organizing them
Great. Note are super important for your co worker and future self
So true!
Thanks, Reid. Great tips! I had never thought to use the Query View for notes. I will try this!
I typically maintain a revision history table in Power Query to log a summary of changes of a published report.
That could work too! Tools like Git integration, or software like PowerOps does make it easy to also compare versions as well between files (expanded beyond just Power Query).
When doing multi-line notes the block syntax is worth mentioning /* */, or just type a bunch of text, select it and hit Ctrl + / (on a UK keyboard) to toggle comments.
Thanks for adding that! Yes for multi-line that comes in handy :)
I've never been that great at keyboard hotkeys, haha.
Very cool, any character limitations when adding code to the description?
I've yet to find any! Including emoji's
as from my experience: user can't see the descriptions in viewer-mode on powerbi service, right? is there a way that they can access the notes? This notes can be helpful if they want to personalize a visual.
Anyone with build permissions who could do self-service reporting can see the descriptions when hovering over the fields.
For people just looking at the report. They wouldn't want to look at the fields list. If you need extra notes for them. The visual header Help tooltip is my recommendation, adds a custom tooltip description, per visual/object on the report page :)
prologika.com/power-bi-visual-help-tooltips/
the PQ step comments are often used. I did not know about comments also for the query
Nice:)
Just a pity there are no better ways than these workarounds.
I think for example, that if you publish the report with the bookmarks, the users can see them as well.
MSFT should come with better ways.
I agree on better location for notes. For bookmarks though, users do have access to the bookmarks pane in reader mode once published. They just don't use it often, but they can see a list of all report bookmarks the developer built :)
I agree, but would I like a mid-point. I would like to hide bookmarks that are being used by devs to add report functionality, but also create 'global' filter type bookmarks that all users can access instead of them all needing to setup or try to share personal bookmarks.
@@workstuff5253 it would be nice to hide bookmarks entirely! I find that using the Bookmark folder can help with that at least. Having top level folders like "Report Users" and "Developers Only" at least separates them and lets people know which are the bookmarks for them to use. Not perfect, but better than not organizing them