Does the PBIDS file type support a Dataflow connection?

[ed-freeman]

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-specifica...) 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

[Pat_msft]

@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>"
}
}
}
]
}

[v-lili6-msft]

hi, @ed-freeman 

Based on my test, It seems that dataflow isn't supported in PBIDS yet.

Regards,

Lin