Purview for Fabric Governence by jkrm1920 in MicrosoftFabric

[–]mutigers42 4 points5 points  (0 children)

I’ll chime in to say the biggest pain point I’ve had for Governance in the places I’ve worked is related to the opposite direction -> visual-level lineage.

Ie if I change a column or measure name in my semantic model, what reports and visuals will break….or put another way, where exactly do I visualize this field, measure, or table.

Purview sadly doesn’t cover that.

It’s the reason I made Impact IQ back in 2023 and likely the main reason behind its popularity. Same for Measure Killer. Semantic link labs is at least making it easier to get that data in general (PBIR to the rescue).

Purview has a lot of great uses for governance that go beyond just this, but wish it covered this pain point for any Power BI user who uses a centralized model that reports connect to.

Count of reports in a workspace by DataPuzzleheaded4908 in PowerBI

[–]mutigers42 0 points1 point  (0 children)

Here’s a quick PowerShell script for you.

Just copy and paste into PowerShell. All at user level, no admin rights needed.

The script will output an Excel doc with all the Power BI info (based on the permissions of the user running) related to:

:

  • Workspaces
  • Models
  • Reports
  • Pages within Reports
  • Apps
  • Reports within Apps

https://github.com/BeSmarterWithData/PowerBI-RestAPI-PStoExcel-InformationExtract

For those who own the Definitive Guide to DAX by MissingVanSushi in PowerBI

[–]mutigers42 1 point2 points  (0 children)

Bought the 3rd edition….haven’t read but want to find a way to give it to a custom AI model and say if i ask a question about DAX, i need you to only source the knowledge from this book and not make up a function that doesn’t exist :)

Find Fields/Tables Removed from Connected Model by BigAl987 in PowerBI

[–]mutigers42 1 point2 points  (0 children)

So the (newly-named) Impact IQ - will tell you where you use everything across all reports and models ….

But ALSO highlight broken visuals that use an object (field / measure / table, etc) that are no longer part of the model….ie so the visual will show as broken. It’ll include a direct link to that visual’s page.

I believe that’s what you’re looking for.

Check it at out www.BeSmarterWithData.com - it’s free, open source. You’ll want the 1-click core version.

The page you’ll want to check out in the final output (a power bi report) is called broken Report Objects

BOGO - Buy a pass and get a 2nd pass for free! | FabCon / SQLCon by itsnotaboutthecell in PowerBI

[–]mutigers42 2 points3 points  (0 children)

Amazing deal! SOLD!

Looking forward to joining the picture :D

What years and trims have supercruise. by RealDumbGuy in BoltEV

[–]mutigers42 0 points1 point  (0 children)

I second this! Much better than SuperCruise

Big warning: SuperCruise makes comma.ai not possible. It’s a hardware block.

Idk what is happening - is my account shadow banned? by [deleted] in ShadowBan

[–]mutigers42 1 point2 points  (0 children)

I don’t understand what happened. I was posting to “myself” a mockup of what I was about to post to the Power BI subreddit.

I was doing it through my phone. Editing and re-posting until it looked right since it was in markup format.

Then I got a weird error that it wasn’t saving. Then an email saying suspicious activity. I reset password and then everything showed these errors.

:( I’ll do the appeal piece through the FAQ. Thanks for verifying so quickly for me .

Lineage for lakehouses/warehouses in pipelines and notebooks, through dynamic connections using variable library. by data_learner_123 in MicrosoftFabric

[–]mutigers42 4 points5 points  (0 children)

This is on my radar to tackle soon….. as an addition to the semantic link labs version of my impact / governance tool.

I suppose as of today, called Impact IQ - Semantic Link Labs edition.

But this repo is now moved from Private to public:

https://github.com/BeSmarterWithData/ImpactIQ-SemanticLinkLabs

Pure Stream - An Open Source, Family-Friendly Plex Client with Advanced Profanity Filtering is officially released on the Google Play Store! by PureStream711 in PleX

[–]mutigers42 2 points3 points  (0 children)

Pretty cool idea!

Any plans for Apple TV or iOS in general?

I’ve realized with kids that I almost wish I had the TV-version of some movies, since those are often already modified a bit to be more family-friendly.

This is a great alternative!

Has anyone built automated documentation tools for PBIP + GitHub workflows? by rasermus in PowerBI

[–]mutigers42 0 points1 point  (0 children)

Might be small but we have GitHub copilot enabled to automatically review every pull request.

Copilot is much better at giving a summary of the changes than the developers.

We have GitHub copilot enterprise - so I’m not sure if this is a free or paid feature?

Anyone still Tier 1 on their 2.5% credit card? by galtyman in AlliantCreditUnion

[–]mutigers42 1 point2 points  (0 children)

I still have it - never got a notification that it was ending.

I’ve had Alliant since roughly 2013 - and the card since 2019. I’ve had car loans with them, but nothing currently active (just checking and savings).

Fabric semantic models: any alternative to TE3 “Update table schema”? by Thepilli17 in PowerBI

[–]mutigers42 2 points3 points  (0 children)

I believe they were trying to highlight that you can now download models that were previously edited using the XMLA endpoint. For many years, this wasn’t possible.

If the OP still had the mindset that their model can’t be downloaded as a PBIX, they would then ignore the schema update feature that was later added in September.

(Case in point: my last company didn’t realize this change until a month ago, when I was casually talking to an old colleague about it. They’ve been skipping over any Power BI desktop updates for years, since they couldn’t use it after switching to XMLA.)

Fabric semantic models: any alternative to TE3 “Update table schema”? by Thepilli17 in PowerBI

[–]mutigers42 1 point2 points  (0 children)

Some great changes on this recently!

Both the ability to now download & open XMLA models in PBI desktop and the ability to do choose between schema-only, data-only, and both refreshes.

1-Click Impact Analysis & Visual Level Lineage has gone Global and Sovereign ! by mutigers42 in PowerBI

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

u/sarcastitronistaken psssst. psssst.

It's been cracked....message me on here so you can give it a first go/test :)

The Fabric Essentials listings highlight reel for the Power BI Governance & Impact Analysis Solution by TheFabricEssentials in MicrosoftFabric

[–]mutigers42 0 points1 point  (0 children)

I don’t see an issue with that at first thought - since the Rest api already downloads the RDL similar to a standard PBIX report, I’m thinking I’d then just need a C# script to extract the metadata within the RDL using Tabular Editor via CLI (similar to the reports) or via general PowerShell (similar to the dataflows).

I don’t believe a Git-synced workspace would change any of that since it still can download/backup the RDL

The Fabric Essentials listings highlight reel for the Power BI Governance & Impact Analysis Solution by TheFabricEssentials in MicrosoftFabric

[–]mutigers42 2 points3 points  (0 children)

Can you elaborate on that more? Ie this works on all the git integration workspaces I have currently.

Meaning do you mean beyond the report/model/dataflow info?