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

Sounds like you would want to put the Excel files in OneDrive and then connect (not import) them to Power BI Service.

GuyJohnson's avatar
GuyJohnson
Kudo Collector
9 years ago

No. The spreadsheet has comments inside the individual cells. These comments do not surface when I inport the spreadsheet into Power BI. I need to be able to see the comment and work with them in Power BI.

 

The location of the file in immaterial

  • 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.