Many people have Excel workbooks stored in OneDrive for Business that would be great for use with Power BI Desktop. With Power BI Desktop, you can use online links for Excel files stored in OneDrive for Business to create reports and visuals. You can use a OneDrive for Business group account or your individual OneDrive for Business account. Download and install the Microsoft OneDrive app for PC, Mac, iOS, and Android. Get OneDrive cloud storage to protect your files and access them across all your devices. Oct 01, 2019 Once opened, click on Info tab Below the name of the Excel file, you will find a link “OneDrive - ” click on that link as shown in the below screen. Then, click on 'Copy path to clipboard'. This will copy the OneDrive path of the Excel file. Get Word, Excel, and PowerPoint plus 1 TB of OneDrive storage to back up and protect your files. Office torrents for mac. You can download files and folders from Microsoft OneDrive, or from SharePoint in Microsoft 365 or SharePoint Server 2019, to your computer with just a few clicks.
-->Many people have Excel workbooks stored in OneDrive for Business that would be great for use with Power BI Desktop. With Power BI Desktop, you can use online links for Excel files stored in OneDrive for Business to create reports and visuals. You can use a OneDrive for Business group account or your individual OneDrive for Business account.
Getting an online link from OneDrive for Business requires a few specific steps. The following sections explain those steps, which let you share the file link among groups, across different machines, and with your coworkers.
Get a link from Excel
Onedrive Excel Formulas Not Working
Navigate to your OneDrive for Business location using a browser. Right-click the file you want to use, and select Open in Excel.
Note
Your browser interface might not look exactly like the following image. There are many ways to select Open in Excel for files in your OneDrive for Business browser interface. You can use any option that allows you to open the file in Excel.
In Excel, select File > Info, and then select the Copy path button, as shown in the following image.
Use the link in Power BI Desktop
In Power BI Desktop, you can use the link you just copied to the clipboard. Take the following steps:
How To Rotate Words In Onedrive Excel
In Power BI Desktop, select Get Data > Web.
With the Basic option selected, paste the link into the From Web dialog box.
Remove the ?web=1 string at the end of the link so that Power BI Desktop can properly navigate to your file, and then select OK.
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 Business sites).
A Navigator dialog box appears, allowing you to select from the list of tables, sheets, and ranges found in the Excel workbook. From there, you can use the OneDrive for Business file just like any other Excel file. You can create reports and use it in datasets like you would with any other data source.
Note
Onedrive Excel File
To use a OneDrive for Business file as a data source in the Power BI service, with Service Refresh enabled for that file, make sure you select OAuth2 as the Authentication method when configuring your refresh settings. Otherwise, you may encounter an error (such as, Failed to update data source credentials) when you attempt to connect or to refresh. Selecting OAuth2 as the authentication method remedies that credentials error.