Forum Discussion

GuyJohnson's avatar
GuyJohnson
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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I respectfully disagree. If you do it the way that I suggest, you will be able to see your comments in Power BI. Again, upload your file to OneDrive and then in the Service, choose Get Data, point to your OneDrive file and choose Connect. One the next screen DO NOT CHOOSE TO IMPORT. Here is a simple test I did:

 

GuyJohnson's avatar
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's avatar
    Greg_Deckler
    Community Champion
    9 years ago

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

    • GuyJohnson's avatar
      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.