Get and Transform Data from an Excel Workbook Published in Power BI

[Anonymous]

I uploaded an Excel workbook into Power BI, but the default options for Get Data in Power BI Desktop does not seem to be able to get from the Power BI Workspace. 

Is this possible to do? This seems like it should be possible but there is no option to do so. Is there a function that does this? Seems pretty basic but I am unable to find. 

The advice here specifies how to upload but does not tell you how to use this in power query after u...

[v-jingzhang · Accepted solution]

Hi @Anonymous 

If you want to get data from an Excel workbook and transform data in Power BI Desktop, you can upload the Excel workbook to OneDrive for business or a SharePoint site you have access to. Then use the method introduced in below link to connect to the workbook in PBI Desktop. 

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Learn

If you want to connect to an Excel workbook located in a local drive, you can use Connect to Excel in Power BI Desktop - Power BI | Microsoft Learn

If you upload an Excel workbook to a workspace in PBI service, currently it is not supported to connect to this workbook from PBI Desktop. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

[lbendlin]

If you want to transform the Excel data you should place it on a Sharepoint/OneDrive, not import it into the workspace.