Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
tanina
Frequent Visitor

Refresh data

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. erreur.PNGmanier.PNG

1 ACCEPTED SOLUTION
Thejeswar
Super User
Super User

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

View solution in original post

4 REPLIES 4
Thejeswar
Super User
Super User

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

@Thejeswar 

Thanks for your help 🙂 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.