Getting Sharepoint excel file in powerbi desktop

[powerbidev123]

I have requirement which asks me to load an excel file which is in my one drive shared by my team members and it gets updated on daily basis. I want to schedule a daily refresh from power bi service where in whenever the file gets updated by anyone the dataset also gets updated. Please suggest a method whi

[bhanu_gautam · Accepted solution]

@powerbidev123 , Try using below steps

Connect Power BI Desktop to the Excel file on OneDrive:

Open Power BI Desktop.
Click on Get Data > Web.
Enter the URL of the Excel file stored in OneDrive. You can get this URL by navigating to the file in OneDrive, clicking on the file, and selecting Copy link.
Authenticate with your OneDrive credentials if prompted.
Load the data from the Excel file into Power BI.
Step 2: Publish the Power BI Report to Power BI Service
Publish the report:
After loading and preparing your data in Power BI Desktop, click on File > Publish > Publish to Power BI.
Select the workspace where you want to publish the report.
Step 3: Schedule a Daily Refresh in Power BI Service