The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to use dataflow gen2 (ci/cd) as a dynamic value parameter in pipelines but there is no way to forward any kind of unique identifier of a dataflow gen2 (ci/cd). With standard dataflows gen2 I would usually put GUID values, but there are no GUID values for dataflows gen2 (ci/cd), not even in json files when they are synced to git. What would be the alternative to get their GUIDs and use them as dynamic values in pipelines if there is one.
Hi @Filipbukvic96 ,
Just checking were you able to get the pipeline running end-to-end after pulling the Dataflow Gen2 ID dynamically? If it’s working smoothly now, that’s great news. If you’re hitting any snags in passing the parameter or triggering the run, we can troubleshoot the exact step together.
Regards,
Akhil.
UPDATE: I have now managed to get the dataflow GUIDs, but still, passing this GUID values to pipeline and refreshing the pipeline does not refresh the Dataflows automatically, I get the error: Refresh Dataflow failed with status: BadRequest, Failure reason: {"error":{"code":"InvalidRequest","message":"Unexpected dataflow error: "}}
@v-agajavelly Not really, I have tried everything but I keep on getting the following:
Invoke-RestMethod : {"requestId":"8cdaf62f-ab9a-412d-9c88-a5d931987e26","errorCode":"Unauthorized","message":"The calle
r is not authenticated to access this resource"}
At line:28 char:14
+ ... Dataflows = Invoke-RestMethod -Method Get -Uri $ListDataflowsUri -Hea ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebExc
eption
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand
How come there is not any other faster way to retrieve Dataflow GUIDs for Dataflows Gen2 (CI/CD), with standard Gen2 it works fine, I would just like to avoid redoing my Dataflows from CI/CD ones into standard Gen2
Hi @Filipbukvic96 ,
Thanks @ibarrau for your inputs. Yes, using the Fabric REST API to list the dataflows and filter by name works perfectly for getting the GUID of a Dataflow Gen2 (CI/CD). I was able to retrieve the ID and pass it as a dynamic parameter in my pipeline. Appreciate the clear pointer to the docs.
Thanks,
Akhil.
Hi. I'm not quite sure what is it that you want to do, but if you want to get the GUID for a dataflow gen2 at a workspace, you could use Fabric Rest API. This is the request for getting them (then filter by name):
https://learn.microsoft.com/en-us/rest/api/fabric/dataflow/items/list-dataflows?tabs=HTTP
I hope that helps,
Happy to help!
User | Count |
---|---|
17 | |
9 | |
5 | |
3 | |
3 |
User | Count |
---|---|
46 | |
23 | |
17 | |
13 | |
12 |