Power BI Lineage
Summary: jennifermontgomery raised concerns about inconsistent Power BI lineage functionality, which has been problematic for them over two years. The issue stems from a mismatch between the Power Query Analyzer's requirement for static information and a script's dynamic column renaming. The suggested solution is to refactor the dynamic rename into a static explicit mapping to ensure accurate lineage, as outlined in the detailed workaround provided by jennifermontgomery.
Anyone having issues with Power BI lineage not working consistantly? We have had 2 years of problems, that we are stuggling with getting lineage to work with Power BI. Would love to hear others experience with it. Below is latest issue and workaround.
Issue Summary
The lineage issue is caused by a mismatch between the Power Query Analyzer’s static analysis and the script’s dynamic column renaming approach. The Analyzer requires all information to be static, but the script dynamically generates its renaming map at runtime. This results in an incomplete lineage map with mismatched source and target column names.
Workaround
The recommended approach is to refactor the dynamic rename operation into a static, explicit mapping. This aligns the script with the Analyzer’s expectations and ensures accurate lineage.
Current Dynamic Implementation (causes mismatch):
Proposed Static Implementation (aligns with Analyzer):
By using this static approach, the column renaming will remain consistent and correctly interpreted by the Analyzer.
Eleftheria Makrydaki
·1 year ago · EditedHello @jennifermontgomery I'm so sorry to hear you've been struggling with inconsistent Power BI lineage for two years—that's certainly not the experience we want you to have. Plus, thank you for taking the time to share it.
If you feel you need to discuss this persistent issue further with our team, please contact your Collibra Representative and they will be able to set up a dedicated discussion with our Product Managers, thank you!
Regards,
Eleftheria Makrydaki | Product Operations Manager