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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jellis1971
Helper III
Helper III

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors