Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Power BI API action error

    Top Contributor
    Posted Jul 22, 2022 09:58 AM

    I'm trying to use the Power BI API (the custom connector is setup and working perfectly) I just configured the workspace scan API

    POST https://api.powerbi.com/v1.0/myorg/admin/workspaces/getInfo?lineage=True&datasourceDetails=True&datasetSchema=True&datasetExpressions=True

    When I run the test connector inside the configuration screen for the connector, I get the expected response back that it was successful. However when I try to use it in a flow it will not configure the array inputs correctly no matter what I do, it either fails to save because the format is not accepted (string vs array) or when I give it an array it adds additional formatting and causes a bad request. It get forbidden when it's not formatted correctly, and "Cannot deserialize the current JSON object..." when I do get a properly formatted workspace array entered.

    Anyone have any ideas?

    Sam Duval
    Data Quality Analyst
    Element Financial
    Indianapolis IN

  • 2.  RE: Power BI API action error

    Bronze Contributor
    Posted Jul 25, 2022 03:03 AM
    would it be a matter of single vs double quotes ?

    Bertrand d'Arbonneau