Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
@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.
i tried to install both ways and it gives the same error
@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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.