Then edit Excel to create data model and PivotTable, and back to Power BI Service to refresh the dataset via 'Refresh Now', the unknown error will throw out and data model structure will not updated in the dataset. If I connect to Excel via ' Import Excel data into Power BI', and create a report from this dataset. Back to Power BI Service, refresh the workbook and PivotTable displays. Then I edit the Excel to add data model and pivot table. In Power BI Service, connect to Excel via ' Connect, Manage, and View Excel in Power BI'. You can create reports and use it in datasets like you would with any other data source.Hi on my test, I uploaded a Excel file to OneDrive for Business which contains a table data without any external connection. From there, you can use the OneDrive for work or school file just like any other Excel file. It allows you to select from the list of tables, sheets, and ranges found in the Excel workbook. If Power BI Desktop prompts you for credentials, choose either Windows for on-premises SharePoint sites or Organizational Account for Microsoft 365 or OneDrive for work or school sites.Ī Navigator dialog appears. With the Basic option selected, paste the link into the From Web dialog. In Power BI Desktop, select Get data > Web. In Power BI Desktop, you can use the link that you just copied to the clipboard.

In the More details pane that appears, select the copy icon next to Path.

You can use any option that allows you to open the file in Excel. There are many ways to select Open in Excel for files in your OneDrive for work or school browser interface. Your browser interface might not look exactly like this image.

Onedrive excel