Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
arun2001mjl
Helper II
Helper II

How to publish PowerBI desktop report to PowerBI Service(Workspace) Automatically.

‎03-07-2023 07:54 AM

Hello All,

 

Is it possible to refresh PowerBI Desktop Report to PowerBI Service(Workspace) Automatically. We have connected powerbi with Direct Query which is SQL Server and we have set Auto Refresh using Personal Gateway but unable to do Auto Publish. 

We are using Pro Version.

 

Please advise.

Labels:
Message 1 of 4
14,982 Views
1 ACCEPTED SOLUTION
Sahir_Maharaj
Super User
Super User

‎03-07-2023 10:36 AM

Hello @arun2001mjl,

 

It is possible to automatically refresh and publish a Power BI Desktop report to the Power BI Service using the Personal Gateway.

 

  1. Set up the Personal Gateway: Install the Personal Gateway on your local machine and configure it to connect to your data source (in this case, SQL Server).

  2. Set up the refresh schedule: In the Power BI Desktop report, go to the "Home" tab, click on "Options and settings", then "Options", then "Data Load", and finally "Schedule Refresh". Here, you can set up a refresh schedule for the report.

  3. Publish the report: Once you have set up the refresh schedule, save the report and publish it to the Power BI Service.

  4. Configure automatic publishing: In the Power BI Service, go to the workspace where you have published the report, click on "Settings" in the top right corner, and then click on "Dataset". Here, you can enable automatic refreshing and publishing of the report.

Let me know if you might need further assistance.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

View solution in original post

Message 2 of 4
14,940 Views
0
3 REPLIES 3
Sahir_Maharaj
Super User
Super User

‎03-07-2023 10:36 AM

Hello @arun2001mjl,

 

It is possible to automatically refresh and publish a Power BI Desktop report to the Power BI Service using the Personal Gateway.

 

  1. Set up the Personal Gateway: Install the Personal Gateway on your local machine and configure it to connect to your data source (in this case, SQL Server).

  2. Set up the refresh schedule: In the Power BI Desktop report, go to the "Home" tab, click on "Options and settings", then "Options", then "Data Load", and finally "Schedule Refresh". Here, you can set up a refresh schedule for the report.

  3. Publish the report: Once you have set up the refresh schedule, save the report and publish it to the Power BI Service.

  4. Configure automatic publishing: In the Power BI Service, go to the workspace where you have published the report, click on "Settings" in the top right corner, and then click on "Dataset". Here, you can enable automatic refreshing and publishing of the report.

Let me know if you might need further assistance.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning
Message 2 of 4
14,941 Views
0
Hollys83
Frequent Visitor
In response to Sahir_Maharaj

‎04-11-2024 01:15 PM

Is schedule refresh no longer an option under data load? I dont see it under Global or current. 

Message 3 of 4
8,211 Views
0
anamscruz
New Member
In response to Hollys83

‎11-18-2024 07:24 AM

i have the same issue

Message 4 of 4
1,502 Views
0

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!

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.

View All