Forum Discussion

Helper V

8 years ago

Automation for Power BI Desktop

Hi All, I am wondering if i am able to schedule my Power BI desktop which have multiple report within and because of job scheduling my entire report will get referesed automatically when my syste...

Tips and Tricks

Kudo Kingpin

8 years ago

Hi,

No Not possible you have to publish the report to power bi serive there you can schedule the data source for refreshing.

Regards,

Bajee.

Helper V

8 years ago

Can you please tell me the way ...

Regards,

Satish

bajee
Kudo Kingpin
8 years ago
Hi Satish,

In power bi desktop you do not have option to schedule the reports what we can do with desktop is we can create and publish reports to server/Service.

After publishing the report you have to configure the gateway for refresh reports,If your using data source is Azure SQL Server then no need to install and configure the gateway.If your using other data sources you have to configure gateway.

After configure the gateway you can schedule the reports for refresh in power bi service.

Regards,
Bajee.
- Satish_Kumar
  Helper V
  8 years ago
  bajee
  
  Then this is not an automated process.
  
  I know we have an option Power BI to publiush but we have to click that publish option maunally.
  
  What i am thinking that we can automate this entire thing and using Macro code we can publish our report on Cloud.
  
  So this is what i am working on....
  
  Any suggestion in that...
  
  Regards,
  Satish
  - bajee
    Kudo Kingpin
    8 years ago
    Hi Satish,
    
    That you can do with C# or some other code.
    
    In our project our C# developer has written the code using C# he was converted as .exe.
    
    Using that .exe file i can able to publish and create and delete the work spaces and i can generate the embed ur's also.
    
    Regards,
    Bajee.