Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Astolfo
Frequent Visitor

Automatic data refresh

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

 

7 REPLIES 7
Astolfo
Frequent Visitor

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
Responsive Resident
Responsive Resident

@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? 

i got a message installing the gateway

 

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

DemoFour
Responsive Resident
Responsive Resident

@Astolfo is this on prem or personal gateway? 

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

DemoFour
Responsive Resident
Responsive Resident

@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
Responsive Resident
Responsive Resident

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors
Users online (464)