Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Power bi community
I'm a beginner in power bi
In my box they put sensors in a hotel to recover energy data (electricity/hot water/cold water) over a period of one year.
I did my first study and report on the month of April and now I want to automate that and do it on other month.
I try to do it with personal OneDrive but it doesn't work. (I'll include a photo of the error that makes me).
Do you have any ideas or tips to give me please ??
i use a fresh version sorry 😕
thanks and Have a nice day community.
Solved! Go to Solution.
Hi,
I get that you data is present in Personal One drive and that you want to use it for your report.
In such case, you can change the connection in Power BI Desktop and publish the reports. But after publishing to keep it automatic (i.e. to schedule refresh) You need a Gateway configured and the data source for this report given access in the Gateway
Only if there is a gateway present and the data source connected to the data source, you will be able to schedule refresh your report
Hi,
I get that you data is present in Personal One drive and that you want to use it for your report.
In such case, you can change the connection in Power BI Desktop and publish the reports. But after publishing to keep it automatic (i.e. to schedule refresh) You need a Gateway configured and the data source for this report given access in the Gateway
Only if there is a gateway present and the data source connected to the data source, you will be able to schedule refresh your report
Thanks for your help
I see what you mean. i tried to do it but without success
Do you have an example a propose me please I look on the Internet for the configuration of the gateway but I have a little worries also:/
Hi,
The Below link gives a detailed information on How to set up your Data sources in your gateway. Going through this should definitely help you with setting your data sources in the gateway
https://docs.microsoft.com/en-us/power-bi/service-gateway-manage
In addtion the below links give information on installation and configuration of On-premise and personal gateway respectively (if you may need it)
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 137 | |
| 102 | |
| 68 | |
| 66 | |
| 64 |