Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I update a worksheet, save, and on powerbi.com when I click to refresh/update, doesn't work:
If you can help me, I would be grateful.
Solved! Go to Solution.
Hi @danielsouza,
You can implement refresh programmatically using PowerShell - https://blog.gbrueckl.at/2017/08/refresh-powerbi-datasets-powershell-azure-runbooks/.
For instance, you can create Windows Schedule Task (time can be set to your needs, maybe 5-10 min) to run PowerShell script which can run dataset refresh in Power BI Service.
@AnonymousYes yes, by the way is working fine the gateway:
But as I see I can only schedule the updates, so the updates are done, but take so long to appear on the reports and dashboards.
I would like to access the Power BI as service, without depending on the scheduled update, and click on the refresh button to see the updates.
Hi @danielsouza,
You can store your report in OneDrive for Business and then connect to it from Power BI Service. See examples here - https://docs.microsoft.com/en-us/power-bi/service-connect-to-files-in-app-workspace-onedrive-for-bus... and https://www.techrepublic.com/blog/microsoft-office/how-to-harness-onedrive-to-keep-your-power-bi-das.... As a result once you update Excel there your report will be refreshed automatically in Power BI Service.
Dear @zoloturu, thanks for showing me this option.
I'm trying to introduce in several customers the BI concept, so I have to use the maximum free benefits I can, as I see one drive is paid.
I just want to update some data in a local Excel worksheet, and then, manually refresh and I see the data online.
Hi @danielsouza,
You can implement refresh programmatically using PowerShell - https://blog.gbrueckl.at/2017/08/refresh-powerbi-datasets-powershell-azure-runbooks/.
For instance, you can create Windows Schedule Task (time can be set to your needs, maybe 5-10 min) to run PowerShell script which can run dataset refresh in Power BI Service.