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

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/

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:

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

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

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

Excel comments | Microsoft Fabric Community

Forum Discussion

Related content

Dynamic Comments

Mobile layout deleted when disabling comments

PowerBI Comments - Pin a comment

Excel file where comments are linked

Excel Subscription