Forum Discussion

ed-freeman's avatar
ed-freeman
Icon for Advocate II rankAdvocate II
6 years ago

Does the PBIDS file type support a Dataflow connection?

It's unclear from the docs (https://docs.microsoft.com/en-us/power-bi/desktop-data-sources#using-pbids-files-to-get-data) whether Dataflows are supported as a connection for a PBIDS file. I've tried numerous things to try to get it to work, to no avail. There's no mention of connecting to a dataflow in the "Data Source Reference (DSR) format for protocol and address information" (https://docs.microsoft.com/en-gb/azure/data-catalog/data-catalog-dsr#data-source-reference-specification) link provided, either.

 

I'm wondering whether Dataflows are classed as a "Blank query" and therefore they aren't supported in PBIDS yet. Could anyone confirm this?

 

Thanks,

 

Ed

Need Help

2 Replies

  • Pat_msft's avatar
    Pat_msft
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    ed-freeman v-lili6-msft 

    Copying from my response on the docs page.

     

    Yes it is possible. The protocol is "powerbi-dataflows".
    Below is a sample.
    Workspace id and dataflow id can be found by clicking on the dataflow in the Power BI web app and looking at the url.
    https://app.powerbi.com/groups/<workspace id>/dataflows/<dataflow id>
    {
    "version": "0.1",
    "connections": [
    {
    "details": {
    "protocol":"powerbi-dataflows",
    "address":{
    "workspace":"<workspace id>",
    "dataflow":"<optional dataflow id>"
    }
    }
    }
    ]
    }