Forum Discussion

ngantd's avatar
ngantd
Frequent Visitor
1 year ago
Solved

User Data Function - Couldn't submit your request from Power BI

Hi, I've currently created a dashboard that used an User data function to allow user to input their url. The dashboard was working fine on the first day, but since then, I haven't been able to submi...
capacities
data hub
  • ngantd's avatar
    ngantd
    1 year ago

    Thanks for all your helps,

     

    Today, I've rechecked the user data function, and it seems to be in official release now. I'm not entirely sure, but I no longer see preview when creating the function.

    So I've tried again but the old item function set is still not working. But when I created a new one, it worked perfectly. I'll update in the next few days to see if the issue appears with this function set.

     

    v-veshwara-msftRegarding your question about Power Apps, I've created it, and it works fine. I just need approval to deploy it to production, so there's no issue with this approach. It's just too complicated for my work.

     

    Thanks

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi ngantd 

 

The error you are seeing is not really from Power BI, it is coming from the Azure Function that your User Data Function depends on. When an Azure Function runs on the Consumption plan, it can take time to start (called a “cold start”), and sometimes Power BI times out with the ServiceUnavailable / WorkloadException error. That is why it may have worked on the first day but started failing later. The best fix is to move the function to a Premium or Dedicated plan, as these do not have cold start issues. Since you mentioned you don’t have access to change the function, you’ll need the owner or admin of the function to update it. If that is not possible, you can try again later, as sometimes the service responds after a delay. Another option is to think about using parameters or What-If tables inside Power BI instead of calling the Azure Function, if the main need is just user input. In short, the problem is with the function service, not your dashboard, and the permanent solution requires a change on the Azure side.

  • ngantd's avatar
    ngantd
    Frequent Visitor
    1 year ago

    Thanks for your help. In my scenario, I need to write back user input, and a what-if parameter can't do that.

     

    A Power App is another potential solution, but managing a separate app for a simple task is inefficient. Additionally, as I remember, it requires a different license type to publish an app to production.

     

    I'll try to get support from the team that manages the Azure.

    User data function is still preview feature but I expected to be able to use it without any configuration from Azure. Hope this issue is fixed once the feature is officially released.

    • v-veshwara-msft's avatar
      v-veshwara-msft
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi ngantd ,
      Thanks for following up.

      User Data Function is still in preview, and as highlighted by rohit1991 , the error is coming from the Azure Function that it depends on. Since you do not have access to the Azure resource, reaching out to the team that manages it is the right approach. Cold start behavior on the current plan can cause these issues, and while your observation is correct, they may continue until the feature reaches general availability.

       

      Please update us if your Azure team is able to make any changes or if the issue resolves over time.

       

      Please reach out for further assistance.

      Thank you.