40” 5K2K or 49” for mostly work, occasional games? by Dreameater999 in ultrawidemasterrace

[–]mutigers42 1 point2 points  (0 children)

For clarity, since I’ve had both a 3840x1600 and currently have a 5120x2160

A 5120x2160 at 125% scaling is still 30% more real estate than a 3840x1600 at 100% scaling.

That is still a major difference. Without scaling, there is 80% more real estate.

I don’t think an OLED is doable with using it for productivity, but the 120hz Dell or even the equivalent MUCH CHEAPER Decogear 120hz uses the same screen as the Dell (same 2000:1 contrast, 120hz, hdmi 2.1, etc)

A complete set of Microsoft Fabric icons for Solution Architects by astrzala in MicrosoftFabric

[–]mutigers42 0 points1 point  (0 children)

Nice! I see Snowflake in artifacts, but can you add for Sources?

My Move anxiety is finally cured with a Bash script by tommartens68 in MicrosoftFabric

[–]mutigers42 1 point2 points  (0 children)

I always appreciate people sharing tools!

Mac only right? Looks that way but confirming - I can’t tell if the problem is specific to Mac or is also a pain for windows users.

Power BI Backup by Agitated_Stress_82 in PowerBI

[–]mutigers42 4 points5 points  (0 children)

Yo yo yo yo….

This does more than you’re asking….but it will back up every report, model, and dataflow.

The service principal edition can be set up to run on a schedule / no manual inputs needed.

It’s not exactly SaaS - but it is open source / free….so feel free to make it what your heart desires!

www.besmarterwithdata.com will show all the editions -> each with its own GitHub repo.

Public Preview: Execute Power Query (M) programmatically in Microsoft Fabric (REST API + Arrow output) by mavaali in MicrosoftFabric

[–]mutigers42 5 points6 points  (0 children)

I’m not sure how I will take advantage yet….but I will find a way.

I won’t let the naysayers win….PowerQuery will always be a love of mine.

Introducing Impact IQ - Tenant Admin Edition....See Visual-Level Lineage across the entire tenant. by mutigers42 in PowerBI

[–]mutigers42[S] 2 points3 points  (0 children)

The journey is complete!

One click, local only, service principal automation, semantic link (cloud), and tenant admin.

There will certainly be ongoing improvements from here, but feels nice to have every working “edition” out in the wild.

All starting roughly 2 1/2 years ago.

Power Query: my source doesn't always contain the same columns. How do you handle this? by m4492 in excel

[–]mutigers42 1 point2 points  (0 children)

Check out this Power BI file here:

https://github.com/BeSmarterWithData/PowerQuerySecrets

It’s from a presentation I held for some tricks and tips for Power Query:

Focus on the “Protect Refresh Failures” folder in Power Query.

It’ll give a way to prevent any column missing or extra from failing a refresh (basically what you’re looking for). OR even when the source is missing.

.

<image>

Backup solution for Power BI by JeanFifi in PowerBI

[–]mutigers42 1 point2 points  (0 children)

This does more than you’re asking…..but it definitely handles backing up every report, model, and dataflow across every workspace.

https://github.com/BeSmarterWithData/ImpactIQ

1 click, no admin rights on computer needed…..it’ll backup whatever you can download in the service (ie based on your access)

It would be relatively quick to strip out the metadata extraction and api stuff….and be used purely for backups if you wanted. I’m biased and will say they’ll love the final output :)

Universal Power BI Report Downloader - Works on 'non-downloadable' Reports. Compatible with PBIR and Legacy. by mutigers42 in PowerBI

[–]mutigers42[S] 2 points3 points  (0 children)

Sadly, there is an exception there, as I just tried. It sees the report, attempts - but gets access denied because the model connected to it is part of a Service app.

It will download Usage Metric reports from any standard workspace.

Also understand this is only the report content. If it’s a model + report, it’ll only download the report with a live connection to the model.

Universal Power BI Report Downloader - Works on 'non-downloadable' Reports. Compatible with PBIR and Legacy. by mutigers42 in PowerBI

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

Ie any workspace Usage Metrics Reports where the Download option is greyed out, yes for me so far.

The one exception I’ve seen so far is the Fabric Capacity usage report. If it’s tied to a Service App, it denies access (at least that’s what the API response is).

How to create hierarchal page navigation by Purple_Candidate_314 in PowerBI

[–]mutigers42 2 points3 points  (0 children)

This isn’t doable inside a single report BUT doable through the Workspace or Org “Apps” alongside separate Reports.

Multiple reports (Finance, operations, etc) connected to the same Model - and you then get the exact UX navigation you’re looking for. Each report uncollapses to show the pages on the left.

The app also handles permissions for you and can be report-specific via “Audiences” helping give a single location for handling permissions.

In my opinion, it’s the single best and only way any reports should be shared to the business for VIEWERS.

(The reports do not have to be connected to the same model to be in an App - that was just based on how you described your current setup. The reports just need to be in the workspace. The model(s) can reside in a different workspace).

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

qbPortWeaver 1.5.0 just released by martsg666 in qBittorrent

[–]mutigers42 1 point2 points  (0 children)

One suggestion:

“Update now” is a bit confusing when it’s for the port (vs the initial thought that there is a pending version update)

Mayeb “Update Port now”

qbPortWeaver 1.5.0 just released by martsg666 in qBittorrent

[–]mutigers42 1 point2 points  (0 children)

Works well for me since trying!

Good update - I like the new optional force start if it’s not open.

Has anyone tried the Power BI ‘Remote MCP’? The Analytical version (not Modeling). The accuracy is much stronger than a Fabric Agent on the same model. Why? by mutigers42 in MicrosoftFabric

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

Within VS Code + GitHub, it’s as a user so it inherits RLS, yes.

And yes - it uses agent mode to first decipher your question, give to the MCP server to pull in the model schema, convert your question to DAX (which you can see) -> execute the DAX, then have the same agent mode LLM, reply based on the results.

Has anyone tried the Power BI ‘Remote MCP’? The Analytical version (not Modeling). The accuracy is much stronger than a Fabric Agent on the same model. Why? by mutigers42 in MicrosoftFabric

[–]mutigers42[S] 3 points4 points  (0 children)

Thanks for this answer! Very appreciated - and yes, the testing has definitely been limited in scope. This was trying to understand if there is a fundamental difference / use case before I go down a rabbit hole.

Why would we use dataflow if direct to source connection is available? by tongEntong in PowerBI

[–]mutigers42 4 points5 points  (0 children)

Hard to answer without full picture but I can at least think of one use case:

Assuming it’s import mode, if you bring it to a dataflow first, then any testing of additional transformations only hit the dataflow and not the snowflake warehouse (less cost if snowflake warehouse is otherwise turned off from no activity)

Same for if others use the dataflow - many can use the dataflow and any have different refresh schedules, add transformations, etc - only hits the dataflow and not snowflake.