power bi report update

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Power BI report to update daily automatically from a Microsoft f

Power BI report to update daily automatically from a Microsoft f

resolvedResolved · Urgent Priority · Version 365

Power BI report to update daily automatically from a Microsoft f

Hi

I have a Power BI report that is currently 'manually' updated with the 'Open in Excel' data set (Power BI > Get data), under a Microsoft Form 'Responses' tab.

Is there a way to connect the Power BI report to the Form's Excel output sheet so it updates automatically on a daily basis or each time the Form is submitted?

Both the Microsoft Form and BI report is located in 'Teams' and 'Sharepoint'.

Many thanks for any help.

- Gordon.

RE: Power BI report to update daily automatically from a Microso

Hi Gordon,

Thank you for the forum question.

To auto refresh Power BI reports the Power BI Gateway needs to be installed on your server.

The Power BI Gateway is a free app which can be downloaded from Power BI Service.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Power BI report to update daily automatically from a Microso

Hi Gordon,

Thank you for the forum question.

To auto refresh Power BI reports the Power BI Gateway needs to be installed on your server.

The Power BI Gateway is a free app which can be downloaded from Power BI Service.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 1 Dec 2023: Automatically marked as resolved.

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Master the Power BI Custom Visuals

Power BI offers a variety of custom visuals created by the community and Microsoft. Explore these visuals to enhance your reports and dashboards. Whether it's a custom map, a timeline, or a unique chart type, custom visuals can add significant value to your visualizations.

View all Power BI hints and tips


Server loaded in 0.06 secs.