search

microsoft / powerbi-powershell

PowerShell community for Microsoft PowerBI. Here you will find resources and source for PowerShell modules targeting PowerBI.
MIT License
342 stars 118 forks source link

function dependentdataset doesnt work for linked entities / layered dataflows #259

Open indexample opened 3 years ago

indexample commented 3 years ago

when i have an Extraction dataflow, and a Transformation dataflow, the transformation dataflow is build upon the extraction layer with linked entities. As per the best practises advised by MSFT.

The extraction layer is the only one that needs a refresh command, since linked entities will automatically refresh the transformation layer.

However, using this script RefreshModel on the extraction dataflow, with the parameter to refresh dependent datasets, it wont refresh the dataset because the function GetDependentDatasets doesnt see a dependent dataset (since a transformation dataset in inbetween, with linked entities). The lineage view does show that these dataflows and dataset are all connected.

indexample commented 3 years ago

i guess it can be solved if this function also gets an extra loop through dependentdataFlows by getting all dataflows in workspace, getting upstream dataflow for each, and compare with current (extraction) dataflow

Then we know the downstream dataflow of the one we are refreshing, and can we get the dependentdataSets of those. (this is only 1 layer deep though)

https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/getupstreamdataflowsingroup