Forum Discussion
Helper IExcel sheet with Power bi
Helper Idear @ashkanduja
thank you for replaing I already add it in one drive then went to power bi
click on Get data -> then web-> and add the file
is this the right way ?
(ou can then set up a scheduled refresh for you power bi dataset.) can you explain this more please
Helper IYes, that's the right way.
Setting up scheduled refresh is fairly straight forward as long as you have the right permissions. See MS documentation here: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
If you still have issues you can PM me and share your screen. I can try and guide you that way.
- albatoul
thank you so much I will try it now then replay to you
Hi albatoul ,
Actually, if your excel file is stored in local mahcine, you could publish the report to service , configure gateway and scheduled refresh to make it automatically update in the Power BI service. If you are a pro user, you could set up to 8 times per day (Premium 48 times)to refresh. For the whole steps, please refer to:
POWER BI AND LOCAL EXCEL DATA REFRESH
Refresh a dataset created from an Excel workbook - local - Power BI | Microsoft Docs
Or as askhanduja suggested, you could upload your excel file in cloud storage such as OneDrive for Business or SharePoint Online.
Here is an official document talking about Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online :
Any data you’ve loaded into your file’s model is imported into the dataset, and any reports you’ve created in the file are loaded into Reports in Power BI.
Power BI automatically connects to the workbook on OneDrive, or SharePoint Online, about every hour to check for updates. If the workbook has changed, Power BI will refresh the dataset and reports in the Power BI service.
Best Regards,
Eyelyn Qin- albatoul
thank you so muccchhh I will try this