Microsoft Fabric Data Pipeline + Power BI API Scanner

[Charline_74]

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

[Charline_74]

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

[v-cboorla-msft]

Hi @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.

[v-cboorla-msft]

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

[v-cboorla-msft]

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.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks

[v-cboorla-msft]

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