Dataset Refresh Automation Using Power Automate
Hello, I'm currently using Power Automate to kick off dataset refreshes automatically based on keywords used in a group chat. With that said, I'm curious about a few things: Is there any way to kick off refreshes of data sets without using PowerAutomate in a specific sequence that I choose based on importance in the organization? If the above is not possible. Then, is there a way for Power Automate to just add the new datasets to the Flow so that someone doesn't have to manage the flow and constantly add the datasets (we're a big org that creates new data sets daily). The end goal is this: Refresh all data sets in a programmatic way instead of having to go to the PBI Server and refresh when a report breaks. In this day of technology, I'm sure someone out there is doing this the right, efficient way.
Container exited unexpectedly - What does this error means?
Hi, I have a dataset scheduled to refresh at 6 pm yesterday. But when I checked the status today, I saw this error message, which I have never seen it before. And at the same time, I got an email said the Data Refresh has been disabled. Data source error: We're sorry, an error occurred during evaluation.;Container exited unexpectedly with code 0x0000DEAD. PID: 8028. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 8028. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 8028. Used features: (none). Container exited unexpectedly with code 0x0000DEAD. PID: 8028.. The exception was raised by the IDbCommand interface. Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: e5f7ee55-cbf0-4fec-91f8-3d54f33bdf4f Request ID: 124e1e7a-be38-4e38-961d-843b07bf3b86 Time: 2020-09-08 01:15:36Z The dataset I'm working on is pretty large (around 10G). And the refresh is scheduled in a premium workspace. In the past, it got throttled several times during a scheduled refresh because of the memory issue on capacity. But I never got this message before. I checked the gateway setting; it's all good. Please help me take a look at the error message, and I really appreciate all help!! Thank you, Kelly
