Forum Discussion
Microsoft Fabric Data Pipeline + Power BI API Scanner
Hello,
I'm looking to set up a data pipeline Fabric, I started by creating a copy data activity to retrieve a list of workspaces. But then I'm stuck, I can't manage to break down this list into packages of 100. Then for each block of 100 call the PostWorkspaceInfo API.
Does anyone have any ideas?
Best regards,
Charline
5 Replies
Hi Charline_74
Thanks for using Microsoft Fabric Community.
Could you please share more details like, how did you set up the pipeline? Can you please provide some screenshots?
Thanks
Hi v-cboorla-msft,
For the moment I just have a copy data activity that allows me to retrieve a Json file from my lakehouse with the list of IDs for my workspaces.
Source API REST :
https://api.powerbi.com/v1.0/myorg/admin/workspaces/modified?excludePersonalWorkspaces=True
Sink : LakehouseHi Charline_74
Apologies for the delay in response.
Have you evaluated Rui's monitoring solution? GitHub - RuiRomano/pbimonitor This is using the scanner API to get all of the catalog and metdata information using a Service Principal account.
I hope this helps. Please do let us know if you have any further questions.
Hi Charline_74
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks
