cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

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-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

2 REPLIES 2
Microsoft
Microsoft

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

Community Support
Community Support

hi, @ed-freeman 

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

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors