Forum Discussion
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
Hey Anonymous ,
I think the proper way now is to go the workspace that you want to use, go to New, Dataset:
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!
5 Replies
- collinq
Super User
Hi Anonymous ,
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.
- AnonymousNot applicable
Yes, I get that far. But, how do you publish it as a dataset? 🙂
- collinq
Super User
Hey Anonymous ,
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....