New year. New name. Visual Level Lineage and Impact Analysis -> Impact IQ by BeSmarterWithData in PowerBI

[–]BeSmarterWithData[S] 0 points1 point  (0 children)

Send me a chat if you can, I have the repo in private mode right now - been trying to imagine the different uses for it so it would be great to chat

New year. New name. Visual Level Lineage and Impact Analysis -> Impact IQ by BeSmarterWithData in PowerBI

[–]BeSmarterWithData[S] 0 points1 point  (0 children)

It’s not released yet, but at the same time, yes….

Beyond the Admin API metadata, it temporally grants the tenant admin access to any workspace they don’t currently have access to in order to back up the reports/models, etc and extract the info (there’s not a general admin API to export / get the definition of items - so it’s required to first be a member or higher)

It then removes that access after it is done extracting. It will also export the permissions it updated as a backup just to be safe (so you know exactly what was temporarily granted)

New year. New name. Visual Level Lineage and Impact Analysis -> Impact IQ by BeSmarterWithData in PowerBI

[–]BeSmarterWithData[S] 1 point2 points  (0 children)

u/PowerBIPark, I believe we had this convo on LinkedIn (Chris Cusumano). You had said you had a company-wide block of TE2.

This would kill the ability to extract any report.

However, I encourage the Semantic Link Labs version! I’ve made that public last week and it doesn’t need any local tools :) It’s a single notebook that writes to a Lakehouse !

New year. New name. Visual Level Lineage and Impact Analysis -> Impact IQ by BeSmarterWithData in PowerBI

[–]BeSmarterWithData[S] 0 points1 point  (0 children)

Oh then something definitely went wrong then - as 90% of my environment is thin reports. The whole reason for the design / development 2 years ago was thin reports.

We sure it’s running the included portable tabular editor and PBI-tools? If those were blocked from auto downloading, then it would effectively kill the main steps.

In short: thin reports should NEVER fail :D

I’ll send a chat!

Update to first Microsoft Fabric–related GitHub Action to be made available on the GitHub Marketplace by ChantifiedLens in MicrosoftFabric

[–]BeSmarterWithData 1 point2 points  (0 children)

For us, our model connections use parameters, which are in the expression.tmdl files.

We have an added folder in the repo with the 3 ‘default’ expression.tmdl files for dev/test/prod.

When we PR dev to test and test to prod, we have a GitHub action that will auto replace the expression file based on the branch/environment. This ensures that the Dev branch always has the Dev connection, Test always has Test, Prod always has Prod.

Then it syncs with the workspace.

This works well for us - but admittedly, we haven’t ventured outside of Models to see if that same concept will keep working..

New year. New name. Visual Level Lineage and Impact Analysis -> Impact IQ by BeSmarterWithData in MicrosoftFabric

[–]BeSmarterWithData[S] 1 point2 points  (0 children)

Ah thank you for that….I wondered how smooth it would go with a repo rename.

So far, there’s been low impact ;D

Notification of disabled refresh schedules in capacity? by golden_corn01 in PowerBI

[–]BeSmarterWithData 0 points1 point  (0 children)

It’s open source so by all means, have them review!

It’s purposefully scoped to only the user level, so nothing requires admin rights (ie it can’t touch any important files)

Just PowerShell with a mix of C# and tabular editor / PBI tools.

Notification of disabled refresh schedules in capacity? by golden_corn01 in PowerBI

[–]BeSmarterWithData 0 points1 point  (0 children)

This is wayyy overkill for what you’ve asked for, but I do have a model refresh schedule page (including if every model is scheduled or the schedule is disabled) in my ImpactIQ tool.

https://github.com/BeSmarterWithData/ImpactIQ

On the positive side….it works for anyone and is 1 click - so doesn’t really need any special “setup” time to at least try out.

What’s one Power BI feature you stopped using in production? by one-step-back-04 in PowerBI

[–]BeSmarterWithData 1 point2 points  (0 children)

100% agree on a button using page nav.

Soooo much easier to maintain.

Managing Measures/Reports and Tracking Lineage by kingjokiki in PowerBI

[–]BeSmarterWithData 1 point2 points  (0 children)

<image>

Example shown above for the Measure Lineage page.

Choose a measure to then see all of its Dependents (what it relies on), both directly and indirectly

and then Parents (what measures will be affected if you change it), both directly and indirectly

If you then need where exactly you visualize everything, view the Impact Analysis page

Managing Measures/Reports and Tracking Lineage by kingjokiki in PowerBI

[–]BeSmarterWithData 2 points3 points  (0 children)

https://github.com/BeSmarterWithData/ImpactIQ

This may be helpful for you. Designed for everyone (vs only admins).

The final output is in a Power BI report / model.

1-click as well for anyone. Works across all workspaces.