cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

refresh automatically published report

Hi all,

 

Is it possible to automatically refresh the publication as soon as a data is updated?


To be more precise, in PowerBI Desktop, I have a database that I update.
I would like the published report to be updated automatically without having to click on the "Publish" button in PowerBI Desktop again.

 

Thank you very much.

 

Jules

1 ACCEPTED SOLUTION

Hi @julespoujol ,

 

If the source datasets come from SharePoint and onedrive, there is no need to configure the gateway, just set the credentials and set the schedule refresh.

test_refresh automatically published report.PNG

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive 

 

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

View solution in original post

8 REPLIES 8
Regular Visitor

thank you @V-lianl-msft 

Microsoft
Microsoft

Hi @julespoujol ,

 

You need to confirm what the connection is.

Refer to:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

After that, you need to install the appropriate version of the gateway.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem 

You can also learn about this API

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdataset 

 

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

Hi all,

 

Thank you very much @V-lianl-msft @amitchandak @Mariusz  but it's not working 😞

To be more precise :

 

1 - I create a dashboard on PowerBI Desktop with 2 kinds of data base :

- One excel file on my Onedrive (entreprise)

- One list on sharepoint

 

Imp ecran Power Desktop.png

 

 

 

 

 

 

 

 

2 - I install Gateway on premise and everything looks find

 

Sans titre.jpg

 

3 - I update my gateway on powerBI service (I mean on the website)

 

Sans titre (2).png

 

4 - I click to add my databse 

 

Sans titre (1).png

 

5 - The warning message appear :

 

image.png

I copy the missing part

Test_4: Informations d'identification de connexion non valides.

Code d'erreur sous-jacent:         -2147467259

Message d'erreur sous-jacent:  Les informations d'identification fournies pour la source SharePoint ne sont pas valides.

 

Which identifiant i have to use ? My email adress Sharepoint and Onedrive Entrprise ?

 

Morever, how can i update automatically my dashboard on powerBI destkop whitout cliking on the button "Update" ? ( I mean, when i update my excel file on Onedrive, the dashbaord change instantly and automatically)

 

Thank your very much

 

PS : Sorry, the screenshot is on French language, but i can translate if you needed

 

Jules

@julespoujol ,

Which identifiant i have to use ? My email adress Sharepoint and Onedrive Entrprise ?

 

What ever you have used in desktop for development. Same need to be used in power BI. 

 

Update without button. As far as know there only option for Live or direct not for import mode. 

 

@Mariusz , looking forward for your update.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thank you @amitchandak .

I'll try again with the same password.

When the form indicate "Identification Windows" that mean I have simply use the name of my session Windows where the files are save (Jules Poujol for my exemple) or I have to put something before (Domain\Jules Poujol for example) ?

Is it possible to use a "LiveConnect" with my excel file save on my One Drive entreprise ?

 

Have a nice day !

 

Jules

Hi @julespoujol ,

 

If the source datasets come from SharePoint and onedrive, there is no need to configure the gateway, just set the credentials and set the schedule refresh.

test_refresh automatically published report.PNG

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive 

 

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

View solution in original post

Super User IV
Super User IV

@julespoujol , refer if this can help

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User II
Super User II

Hi @julespoujol 

 

You can schedule refresh in the service, use Power Automate, Power shell or Automatic Page refresh, please see the links below.

 

https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh#:~:text=schedule...

 

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

 

https://insightsquest.com/2019/03/03/refresh-power-bi-datasets-with-powershell/#:~:text=Dataset%20Re...

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors