One drive refresh not working

Hi VivianaTudora,

---

I manged to connect PowerBI desktop to the Excel files by getting them from the Onedrive folder on my computer. However if I try to do get data, Web and use sharepoint, onedrive it tells me my credentials are not valid. 

 

---

You should choose SharePoint Folder data connector and enter the SharePoint site URL instead of the complete folder path, similar to:

https://microsoft.sharepoint.com/sitename/subsitename

---

With the refresh part I didn't manage the have the onedrive date refresh hourly as many sites say. Where would I be able to access this feature? 

 

---

Please upload your .pbix file to OneDrive or SharePoint online. Otherwise, please add data source to personal data gateway.

Reference: 

Refresh a dataset stored on OneDrive or SharePoint Online

Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online

---

I am currently publishing on web and sending the report this way to all users as none of them have PowerBI. Is there any way to have the Published report on web also refresh once the Desktop App report is refreshed? 

 

---

After you publish report to web, data refreshes are automatically reflected in your embedded report or visual. Reference: Publish to web from Power BI

Best regards,

Yuliana Gu