Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. 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
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 42 | |
| 30 | |
| 24 |