Automatic data refresh

[Astolfo]

Hello everyone,

i created a report in power bi desktop and then published it on service for my colleagues to see. The data are stored in some excel files and are updated every week. I would like to know if there's a way to update the report automatically every week, when the excel files are updated.

Many thanks

Best regards

[Astolfo]

You mean into the report i see in service? if yes i try to do this but it says scheduked refresh disabled 'cause data source credentials are missing and i cannot click on  data source credentials because is greyed out

[DemoFour]

@Astolfo do you have the right permissions in your tenant? 

You should be able to connect up the data source to the gateway, but then I am tenant admin in a premium capacity so I get to do lots of things! 

Do you have an admin you can work with or do you do it all yourself? 

[Astolfo]

i got a message installing the gateway

Error generating an asymmetric key.
Exception message: registered Keyset invalid.

[DemoFour]

@Astolfo is this on prem or personal gateway? 

[Astolfo]

i tried to install both ways and it gives the same error

[DemoFour]

@Astolfo 

That seams like something you internal IT help desk need to help resolve also check out this topic 

Solved: Personal Gateway Error - Microsoft Fabric Community

[DemoFour]

@Astolfo 
You can go into the report and set a scheduled refresh and then link the files to the gateway and set your refresh times. 

Refresh a dataset created from an Excel workbook - cloud - Power BI | Microsoft Learn