![]() My understanding from the Microsoft doc linked above is that if my source files are saved on a Sharepoint Online site, the PowerBI dataset will automatically refresh itself if there is a change to the source file in my case the two Excel spreadsheets. So I know that permissions are configured correctly and the links to the spreadsheets are correct since the PowerBI service allows me to both schedule a refresh as well as manually refresh. In both of these instances, I can successfully connect to the data, publish the dashboard, and can schedule a refresh. ![]() ![]() I have tried using Get Data to import the file as a Web link as well as the Sharepoint Folder connector. I have been unable to get this working after trying multiple different ways of importing the data to PowerBI and manipulating/saving the spreadsheets. If you make changes to the workbook (stored in OneDrive or SharePoint Online), those changes are reflected in your dashboard and reports within an hour. Power BI automatically checks the file, about every hour, for updates. " When you connect to a file on OneDrive, or SharePoint Online, your reports and dashboards will show data as it is in the file. The PowerBI desktop file is also saved in the same document library.Īccording to the Microsoft doc Data refresh in Power BI: ![]() I am attempting to setup a simple Dashboard to automatically refresh (not scheduled refresh) from two Excel spreadsheets that are saved on a Sharepoint Online document library.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |