Forum Discussion
Refresh failure in Dataset created with Excel file
Hi adrian84 ,
In desktop, although it is a live connection to the dataset in the service, this dataset is based on the onedrive import mode, so it is not updated in real time, but almost every hour. If you want to refresh immediately after adding data, please refresh the dataset manually.
BTW, you can use desktop to connect Excel files on onedrive directly instead of importing them in service and then connecting.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi adrian84 ,
In desktop, although it is a live connection to the dataset in the service, this dataset is based on the onedrive import mode, so it is not updated in real time, but almost every hour. If you want to refresh immediately after adding data, please refresh the dataset manually.
BTW, you can use desktop to connect Excel files on onedrive directly instead of importing them in service and then connecting.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much!
Thanks to all the others that tried to help me as well.