PowerBI Lineage

[BenMoss]

Hi there,

I am looking for advice on interpreting the following message on the 'PowerBI Metadata Loader' homepage. In our case we are not succesfully seeing lineage between reports, datasets and ultimately the database and it's tables/columns that connect to those datasets.

I believe this is likely due to this limitation noted by Alteryx:

After removing the DataMashup file by Microsoft for the newly created Power BI reports, the possibility to create a lineage for new Power BI reports has been lost (for new reports). In case you can't see the lineage for your report, republish the report for the lineage to be corrected and re-run the Power BI metadata loader. 

However I'm not sure how to interpret the solution, is it saying that by simply republishing the PowerBI report then the DataMashup file will then become available again? I can't see anything in Microsofts documents that this would be true.

Thanks

Ben

[PetrH · Accepted solution]

Hi @BenMoss , 
just to reconfirm, you should have the Connect version: 2021.4+
the 2021.4 is using the new PowerBI endpoint (Scanner API)  which basically provide similar information as the removed DataMashup file.

If you have just the report on PoweBI and do not touch it for years, it would probably not be exposed to this end point and thus Connect would not able to see the lineage.
With re-publish we mean you need to refresh a connection in report and publish it again in order to include it in Scanner API.
Hope it explains the missing piece.
referring to Connect release notes: https://help.alteryx.com/release-notes/connect/connect-20214-release-notes
Petr

[BenMoss]

@PetrHthank you for your response this is helpful, unfortunately we are working with 2021.3 Alteryx Connect.

Can I ask whether it is okay to use Connect 2021.4 with Server 2021.3?

Ben

[BenMoss]

Or alternatively, can we use the 2021.4 loader with 2021.3 Connect?

[PetrH]

Hi @BenMoss I think, it would be best to use 2021.4 Power bi loader only with 2021.3 connect

[BenMoss]

@PetrHthank you for pointing us in the right direction, it looks like the 2021.4 loader on 2021.3 connect will work for us!

Ben