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

Community Champion

9 years ago

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

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
  - GuyJohnson
    Kudo Collector
    9 years ago
    Will be voting for it. So many people use the comments to keep the Spreadsheet cleaner. But there are times that the comments are useful in Power BI
- GuyJohnson
  Kudo Collector
  9 years ago
  Thanx for link - I'll give that a try later today and see what happens.