Forum Discussion

Kudo Collector

9 years ago

Excel comments

I have many Excel spreadsheets that in which the users have placed comments into the cells. How can I put these spreadsheets into Power BI and be able to utilize the comments that are there

GuyJohnson

Kudo Collector

9 years ago

Okay that does work but how am I going to use those comments in a dashboard.

Also I want to go through the Desktop as there are more powerful option there.

Greg_Deckler

Community Champion

9 years ago

This is the only route that I know of that supports Excel comments.

GuyJohnson
Kudo Collector
9 years ago
Thanx for the help. It gets me part of the way.

There needs to be a way that these comments can be "surfaced" in the desktop version of Power BI.
- Anonymous
  Not applicable
  9 years ago
  Can you 'surface' the comments into cells in the Excel workbook (where PBI Desktop can get at them) using a user-defined function - e.g. http://chandoo.org/wp/2009/09/03/get-cell-comments/
  - Brian_M
    Continued Contributor
    9 years ago
    I was hoping that if you put the file onto OneDrive you might be able to GET the comments using the Graph API. I've done some research and it seems the comments aren't avialable through the API yet.
    
    You could vote for that here
    https://officespdev.uservoice.com/forums/224641-feature-requests-and-feedback/suggestions/7172636-create-a-function-to-bring-in-cell-comments-into-a

Forum Discussion

Excel comments

Related content

Dynamic Comments

Mobile layout deleted when disabling comments

PowerBI Comments - Pin a comment

Excel file where comments are linked

Excel Subscription