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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jellis1971
Helper IV
Helper IV

Excel Workbook as a Dataset

Hi:

Is it not possible to upload an Excel workbook to the Power BI Service and publish that workbook, as a dataset?

Thanks!

John

1 ACCEPTED SOLUTION

Hey @jellis1971 ,

 

I think the proper way now is to go the workspace that you want to use, go to New, Dataset:

collinq_0-1691599670294.png

 

 

 

And THEN select Excel and away you go.  That may have always been an option and new way to me, or, that is a newer method than I have used in the past, either way that worked for me!

collinq_1-1691599696291.png

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

5 REPLIES 5
collinq
Super User
Super User

Hi @jellis1971 ,

 

Yes you can (assuming you have the right permissions to do so).  In the Workspace, select Upload and upload the Excel file to your workspace.

collinq_0-1691596403285.png

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Yes, I get that far.  But, how do you publish it as a dataset?  🙂

Hey @jellis1971 ,

 

I think the proper way now is to go the workspace that you want to use, go to New, Dataset:

collinq_0-1691599670294.png

 

 

 

And THEN select Excel and away you go.  That may have always been an option and new way to me, or, that is a newer method than I have used in the past, either way that worked for me!

collinq_1-1691599696291.png

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Hey @jellis1971 ,

 

It used to "just work" where you uploaded the file (and if the file was formatted correctly) it would become a dataset, as described in this article:

Tutorial: From Excel workbook to a Power BI report in Microsoft Teams - Power BI | Microsoft Learn

 

I will keep looking as this doesn't seem to be the case anymore....

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thank you, collinq!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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