Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jer_Shern
New Member

How do I paste Excel tables to PowerBI as Microsoft Excel Worksheet Object?

 

Capture.png

Hi everyone, I'm trying to move from PowerPoint to PowerBI. My data source is Excel. Usually if I want to present data in PowerPoint from Excel, I would copy from Excel and paste in PowerPoint as a linked Microsoft Excel Worksheet Object. That way it retains all the formating and style of the original table in Excel, and I am able to refresh it by right clicking the object.

 

I would like to do the same but this time using PowerBI. Is there a way to copy a table from Excel and paste it in PowerBI as a linked Microsoft Excel Worksheet Object? Uploading the Excel data directly to the PowerBI would not work for me since it does not retain the formatting and styles. In addition, there are many hidden rows and column in my Excel files which would make transforming the data in PowerBI really tedious. Also, there will be many Excel files, tables and sheets involved so transforming the data one by one would not be ideal.

 

Any help is much appreciated, thank you!

4 REPLIES 4
Jer_Shern
New Member

@amitchandak  Thank you for the great suggestion and sorry for the late reply, I have gone through the videos and tried it myself, the suggestion technically could solve my issue since the dashboard is able to present the Excel table as is, while retaining the style and formatting via the embeded link. However, this is only available for paid subscription members right? What about for free users? Is there any workaround on it? I will continue to find a viable solution for free users. Thank you.

amitchandak
Super User
Super User

@Jer_Shern , No. You can upload data. Or you can upload on SharePoint tor one drive and use that link or URL 

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables

Hi @amitchandak , I have read through the article you had given. However, I do not understand as how adding URLs to a table helps. Am I able to retain the the original Excel file's table view, formating and styling with the URL?

@Jer_Shern , There is one more way, adding excel in power bi service app from SharePoint. These are for different usecases. But see if that can fit in you requirements 

 

Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.