how to get alerted if dataset refresh failed if the refresh is not on schedule and triggered via api from Power Automate?

A really interesting example here. Thanks for posting.

I just found today that I'd left my F2 capacity turned on for a few days (urgh!). I've now implemented your solution (although I found that the Invoke resource operation step now needs parsing (using parse json) to get the "State" to use in the condition. Thank you so much for this video. It will save me a lot of money when I forget in the future!

please share links for blog and doc

Is there a way to avoid duplicates due to the update of a record that is part also of the historical data?. I keep getting this error when running the refresh in the workspace. Column '<oii>GRP Number</oii>' in Table '<oii>Fact>' contains a duplicate value '46131' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Thanks<1

This works and the notebook gets called. When the notebook finishes running correctly power automate then fails saying ""Unable to process the operation due to an error in the request".

Hi, I'm using MS fabric trial version and now installed fabric metric capacity app. Given the trail version capacity Id while installing the app. The app installed but the report is not showing any data. Any idea why this happens?? Please reply

Bro you saved me a lot of time. Thanks!!!!

hey this was really helpful but how do you authenticate. Because normally with sharepoint connectors I can log in with my credentials and its fine. However with the JSON REST Api method it seems to reject that.

Thank you for your video. I have already added the status (jalon) of my projects on the Gantt, I need to color the task with a specific color for each the actual status (jalon) for each project. Example : "name": "coloursDark", "value": [ "#DE5320", "#FFC000", "#92D050", "#00B0F0", "#0070C0", "#008080", "#B3B3B3" ], "on": [ { "events": {"data": "jalon"}, "update": "datum.jalon === 'En attente d''analyse' ? '#DE5320' : datum.jalon === 'Pré-mandat' ? '#FFC000' : datum.jalon === 'Mandat' ? '#92D050' : datum.jalon === 'Appel d''offres en cours' ? '#00B0F0' : datum.jalon === 'Évaluation' ? '#0070C0' : datum.jalon === 'Contrat en cours' ? '#008080' : datum.jalon === 'En attente de terminaison' ? '#B3B3B3' : '#000000'" } ] We should have the same code for the coloursLight. I try this and some think is wrong on my code. Thank you for your help.

What I great video. I just saved it for future reference. On thing caught my attention, when using the Linest/linestx functions, is there a P-Value column? Thanks!

Putting the Metrics app on a Premium Capacity is counter productive, especially if it is the capacity you are monitoring. In addition to Power Automate you can use Fabric Reflexes to be notified about exceeded thresholds. Oh, wait, never mind 😞

Thank you , this is really helpful

One thing you fail to acknowledge is that goes across the top of the chart which blocks the true results of the first bar while scrolling. Essentially "Product 1" stays no matter what.

thank you, this is really helpful

🐐

Thanks for sharing! I have a problem when trying to set up the "Invoke an HTTP request" action. When trying to log in i get the following error: "Create and authorize OAuth connection failed. AADSTS65002: Consent between first party application and first party resourcemust be configured via preauthorization - applications owned and operated by Microsoft must get approval from the API owner before requesting tokens for that API." Did you register an app beforehand in azure? Did you set any specific api permissions? Any idea how to solve this? :)

this a great video...but how do we apply this on an actual dataset? this will be helpful

thank you so much for sharing. It really works, amazing!! 🙂

Thank you very much! 🤩

Do you have any suggestion to a semantic model that takes forever to process after conncting to a sharepoint file? File has a little over 5000 rows with 16 columns.

This is Gold- thanks !

Did someone managed to create hourly gantt?

I tried it but it keeps on throwing errors for column not found and the error is not giving information on which table it’s referring to…I checked all my tables and all the steps are the same and it works on my file without incremental refresh set-up…

That was really helpful! thanks for sharing.

Is there any way to add week no of the year and fiscal quarter columns as well ?

Omg, thank you so much. It worked perfectly with 4-5-4 calendar as well. I spend so much time and nerves to figure out this staff. But here the hero comes along with all solutions ))

Thanks for this! Question though, do you know if this type of set up in the queries is still compatible with the scheduled online refresh?

Thank you for this tutorial. I was able to create an auto-scale Logic App based on the information you provided. I encountered (and resolved) two smallish issues in my build. First, our capacity administrators list was getting deleted every time the Logic App ran. It turns out that the "Create or update a resource" action overwrites the capacity. If you have tags or administrators set up, they get erased. The reason is that the action executes a "PUT" command on the API. You can get around this by calling the API via an HTTP action and using a "PATCH" command. The second issue I had was querying the metrics to see how close we were to the limits. I discovered that that step fails if the capacity is already past the limits -- that is fairly likely to happen if you start at F2. I fixed it by having the capacity go to the next level if that step fails. My Logic App does not allow the auto-scale to exceed a specified maximum, even when that step fails.

are you able to view several capacities at the same time using the Fabric Capacity Measures? I was having trouble passing multiple parameters of capacityIDs for the app.

Hi, thank you, which licenses are required to set this up? 365 E5 for managing Azure Fabric? Power Automate license (which one?)?) Visual Studio License?

Thanks for this explanation!

Thank you 🙏

This video save my life! Helps me alot!

Do we need PowerBI Premium or use Direct query for this approach

Can you share the pbix file?

The pan/zoom is amazing and definitely needed thank you!

awesome information! Thank you for sharing!

Hi Thanks for your video and code. But unfortunately the flow test fails at the compose step stating 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'

This is amazing.

custom report name is not working for me. it is giving error. could you please show how to add the custom report name value

Great video Pat!

I did get the process but how to combined data (old and new) while perform latest dashboard.

I love this video series, just wanted to see if we could get the excel file, as I have tried to see where it is saved, but I haven't seen it in your links. Thanks for the content.

"promo sm" 🏃

How can I apply this to a Document Library instead of a list?

Thx! Great Overview on interesting approaches (Binary Load splitted)

I appreciate the effort and thought I could get this to work but the environment variable , instance url, does not work.

Hi, thank you so much for this video. I follow same steps as you with dates, split the column to dates and time, in the query editor the changes are applied. However, when in move the the frond end (view table) the changes are not applied in times. I get 0:00:00 as a result. Do you maybe know why ? Thank you in advanced

Great stuff Pat. Keep them coming, these type of videos are helpful to the community.