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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Mx_lrn
Regular Visitor

Automatic refresh Power BI report from a local excel file

Hi everyone,

What can I do so that everytime I modify a local excel file, the Power BI report (on Power BI service) based on this file automatically updates ?

 

Thanks

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. The way to update onpremise data to Power Bi Service you need a Gateway that will help you move the data automatically with a schedule refresh. You can schedule the refresh up to 8 times a day in regular licences (free or pro) and up to 48 times in a premium licence.

You can follow this post to get started or microsoft doc

https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

5 REPLIES 5
Mx_lrn
Regular Visitor

Yes I heard about that and I have now a gateway, but I don't know how to link them and how that's going to automatically update my Power BI reports

Thanks for your answer !

Please check again the link I have sent. I know it's in spanish but you can ask the browser to translate it. That link is showing what to do from the installation until you have everything set up with the schedule refresh. At the end of the post you should have your powerbi configured to refresh N times a day (with your machine turned on of course).

You can also check this video if you like videos more: https://www.youtube.com/watch?v=Vlv1tbuZNcM

Just to be clear. There is NO way to have the power bi updated each time you change something on the excel. The refreshes are scheduled at specific time of days. You can manually refresh, but that's up to you.

I hope that helps,

P/D If you are looking for refreshing the data without your machine on, you should consider onedrive or sharepoint.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Thanks, I read the article. There's just one problem : when I try to add a new data source, I can't select Excel, there's a huge list of propositions and I don't know which one to choose

Hi there! you can use the Data source type "File" for a local excel, csv, txt, etc. It will automatically identify the extension once loaded.

I hope you can finish the configuration 🙂


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

ibarrau
Super User
Super User

Hi. The way to update onpremise data to Power Bi Service you need a Gateway that will help you move the data automatically with a schedule refresh. You can schedule the refresh up to 8 times a day in regular licences (free or pro) and up to 48 times in a premium licence.

You can follow this post to get started or microsoft doc

https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors