Forum Discussion
Get and Transform Data from an Excel Workbook Published in Power BI
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!
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!