Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have created a couple reports on PBI Desktop with data from a SharePoint List and Excel spreadsheet from a SharePoint Folder. I published the reports to the Power BI online app and want to schedule refresh.
I'm just wondering if I add something to my SharePoint List and schedule a refresh, will it not refresh straight to the Power BI Online app? For example, when I manually click refresh on my PBI Desktop, the new data gets inputted, but how am I able to have the new data inputted directly onto the online reports without having to manually click refresh on the PBI Desktop? Am I missing something?
UPDATE: I guess my ultimate question is do Power BI online reports schedule a refresh and pull data from the SharePoint List or the Power BI Desktop?
Because I just successfully did a scheduled refresh but it only uploaded the new data that was manually refreshed on my PBI Desktop, rather than the new data from the SharePoint List that I added
Thank you!
Solved! Go to Solution.
After scheduling it to refresh again, the new data has appeared. This is very strange. Before I thought I saw the new data, but it disappeared and now it has reappeared. I guess my problem is solved for the moment!
Hi Gilbert,
I did install the On-Premise Data Gateway (personal) but it says that "You don't need a gateway for this dataset, because all the data sources are in the cloud, but you can use a gateway for control over how you connect."
If I enable it, it will refresh my data DIRECTLY from SharePoint Online List to Power BI Service? After some Googling, I read that the only way this is possible is by using Direct Query. Thoughts?
Thank you for helping
After scheduling it to refresh again, the new data has appeared. This is very strange. Before I thought I saw the new data, but it disappeared and now it has reappeared. I guess my problem is solved for the moment!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.