Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello.
I have about 15 tables in my report that should be updated automatically once a month except for one that should be updated hourly or even more often. This table contains so-called comments, which should be refreshed on a regular interval. At the moment I have two solutions:
1. updating automatically the entire report daily, which I don't want to do
2. updating manually, just one table and publishing the report manually every day
Both solutions do not solve the problem in any way. in the long term.
I tried to solve this issue using the method from the following video
https://www.youtube.com/watch?v=OYYnoMa-93g
using this program - Microsoft SQL Server Management Studio. It is works fine, but I do not know if it is possible to set up this program in such a way that I configure it once and that it performs the update by itself, for example, every hour, because at the moment it is so that as long as the program is on and I perform the update manually, it also affects the report. On the other hand, if the program is turned off, I stop updating the table in the report.
Regards Piotr.
Solved! Go to Solution.
Hi, assuming you have PPU or premium have a look at the Enhanced Refresh in the Rest API.
Chris Webb has just put out an excellent 4 part blog on calling it with power automate.
Hi, assuming you have PPU or premium have a look at the Enhanced Refresh in the Rest API.
Chris Webb has just put out an excellent 4 part blog on calling it with power automate.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |