Forum Discussion

PANDAmonium's avatar
PANDAmonium
Icon for Resolver IV rankResolver IV
5 years ago
Solved

Check which reports are using a dataflow

Is there a way to check which reports are using a dataflow? I planned on deleting a couple old dataflows, but wanted to verify that there aren't any reports currently using them. Thanks!
Need Help
NatachaPN's avatar
NatachaPN
Frequent Visitor
5 years ago

Hi! Following your suggestion, I am developing a process to detect orphaned dataflows in my environment, using API REST in PowerAutomate.  

I have a Dataset conected to a couple of Dataflows plus a list on Sharepoint.

When I check the sources of this Dataset ID, with:


GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/datasources

 

I receive a response that contains only two datasources 

I have test with others examples, and are the same. The responses has datasourceId that I cannot find as ID of my dataflows. I wonder if I should run other API using the datasourceId in a loop.

Could you suggest me some improvement?

rjhale's avatar
rjhale
Icon for Helper V rankHelper V
5 years ago

NatachaPN I'm struggling with the same thing right now.  I'm finding the dataset ids without any problem using the datasources endpoint, but those appear to be unique to the dataset.  Did you ever find a way to use information to correlate the dataset to a particular dataflow?  

  • NatachaPN's avatar
    NatachaPN
    Frequent Visitor
    5 years ago

    unfortunately, not yet