Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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>"
}
}
}
]
}
hi, @ed-freeman
Based on my test, It seems that dataflow isn't supported in PBIDS yet.
Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |