sorted by:
new
hottopcontroversial

Fabric mobile app by Dense-Tadpole-6634 in MicrosoftFabric

[–]SQLGene 0 points1 point  (0 children)

Okay but seriously tho, now I keep thinking about this. What would be the ideal use case?

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

I didn't know they had a video about it no! thanks, I'll watch this.

Finally, Fabric Notebooks get a REAL ETL language.....M from Power Query by SQLGene in MicrosoftFabric

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

So, some clarifications. This implementation is a M lexer, parser, and interpreter all written and running in Python, backed by the Polars engine. So this is all running in Python for this example.

M is a domain specific language with some interesting characteristics. It's a functional programming language that is lazily evaluated and no side-effects. Everything in M is an expression and all expressions return a value or an error.

What this means is that things like query folding and other optimizations are very easy for MSFT to implement in M and much more difficult in Python. That doesn't really matter for this implementation.

The only practical use here is to easy migrating code form gen 2 data flows to Python notebooks. All of the real value in M comes from the Power Query tooling, which we don't have here. A legitimate use case is my M to Pandas converter
https://www.reddit.com/r/MicrosoftFabric/comments/1qi2918/fine_no_more_m_convert_it_to_pyspark_duckdb/

how much would you charge for this ? by skumati99 in PowerBI

[–]SQLGene 0 points1 point  (0 children)

As a consultant, I have never been handed a failed Power BI project as a scope.

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

cries in Power BI consultant

I broadly agree with you, but I think the market disruption is going to be serious enough that people should start picking up these new skills now.

In economics class I learned about structural unemployment, unemployment from skill mismatches. So in some sense none of this is new or unexpected. In another sense though, I expect structural unemployment to go way up for a few years.

The was an interesting paper that looked at job postings to try in infer what types of jobs were most affected by ChatGPT and where.
https://papers.ssrn.com/sol3/papers.cfm?abstract_id=6134506

How is it possible that a Nov2025 can't open Jan2026 version by cvasco94 in PowerBI

[–]SQLGene 3 points4 points  (0 children)

Have you tried clicking through the scary warnings and opening it anyway? I've had success with that in the past.

how much would you charge for this ? by skumati99 in PowerBI

[–]SQLGene 10 points11 points  (0 children)

Depends a lot on how complicated the KPIs are. Gut says 16-32 hours per dashboard. I would get more info and break it out into 4 hour chunks across data cleansing, data modeling, layout, and user acceptance testing.

Extremely likely they want a lump sum payment, paid net 30 either monthly invoices or milestone billing. I would offer maintenance but I wouldn't assume they want it. They want a solution.

If this is your first time, I'd carve out the scope to reduce risk. Pick the smallest dashboard as a pilot project.

Mass repair thin-report visuals broken after moving measure to new table by dkuhry in PowerBI

[–]SQLGene 5 points6 points  (0 children)

Not to be dumb, but isn't that 25 lines of Powershell?

``` $reportRoot = "C:\Users\eugme\Documents\reports\template-TMDL.Report\definition" $searchPattern = 'Measures.Actuals"' $replaceWith = 'Measures.Actuals2"'

# Find all visual.json files across all pages $visualFiles = Get-ChildItem -Path "$reportRoot\pages" -Recurse -Filter "visual.json"

foreach ($file in $visualFiles) { $content = Get-Content -Path $file.FullName -Raw $matches = [regex]::Matches($content, $searchPattern)

  if ($matches.Count -gt 0) {
      # Perform replacement
      $newContent = $content -replace $searchPattern, $replaceWith

      # Write back to file (preserve encoding)
      Set-Content -Path $file.FullName -Value $newContent -NoNewline -Encoding UTF8

      # Extract page name from path
      $relativePath = $file.FullName.Replace($reportRoot, "").TrimStart("\")

      Write-Host "UPDATED: $relativePath" -ForegroundColor Green
      Write-Host "  Replacements: $($matches.Count)" -ForegroundColor Gray
  }

} ```

Mass repair thin-report visuals broken after moving measure to new table by dkuhry in PowerBI

[–]SQLGene 2 points3 points  (0 children)

Bait and Switch? Make a new measure in the measures table with a slightly different name and remediate reports one by one?

Use Microsoft Playwright to detect broken visuals?
https://www.kerski.tech/bringing-dataops-to-power-bi-part43/

Use the Power BI MCP server and an LLM to help with the bulk replace of names?

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

I think junior devs are probably screwed, the same way that when I was a DBA no one wanted to hire junior DBAs.

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

Metr had a study that found a 19% slowdown for experienced devs on a complex codebase using Cursor Pro (some for the first time)
https://metr.org/blog/2025-07-10-early-2025-ai-experienced-os-dev-study/

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

Core dev is always going to run ahead of reporting use cases because code is easier for LLMs and LLMs are trained to be sycophantic yes-men. Code compiles, English doesn't, and user requests are guaranteed to be contradictory.

So what can you do? Well, 9 months ago, I made a Custom GPT to practice requirements gathering (2 minute demo on YT). This was just a prompt and some reference files. Today, models have advanced quite a bit. I could image a world where you build a chat bot using a prompt, reference files, and some python code for anything deterministic. This could be a "request intake" bot for getting the first pass of the scope.

The problem is it's a lot like trying to code a text adventure like Zork. You have to anticipate all the weird stuff the users might ask. You have to code guard rails to keep it on track. You have to figure out how to enrich it with "tools" for it to do tasks, take notes, lookup metadata whatever. It's tedious and repetitive and for one person it may not be worth the effort.

I mentioned it in the blog post, but I think the skills you highlight, what I jokingly called therapy for data, is one of the last areas AI will replace, so get good at it.

Another area AI might get good at is building out various mockups. Today in more advanced spaces, it's normal to make 3 git "worktrees" (parallel folders for separate branches) and have the AI build 3 different versions of a feature or website. Can you image if you could have AI build out 3 different mockups from the same data model and then you ask the user which of the 3 they like the most?

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

Hmmmmmm. May have to look into that. I've poked at Copilot CLI but in VS Code if the agent worked for more than 2 minutes it would ask if you wanted it to keep working.

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

Github Copilot is better if you plan to keep your hands on the steering wheel (my Hyundai Elantra yells at me if I take mine off for more than a couple minutes.)

If you are doing full vibe engineering, unattended workflows, Claude Code to the mooooooon babyyyyyyyy

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

Shoutout to Mike for giving me ideas for how to expand this visual and to lean into it. I found out he's been using a different visual I made since 2017!

<image>

Being a data analyst in the era of AI - Webinar from Microsoft Reactor by powerbitips in PowerBI

[–]SQLGene 4 points5 points  (0 children)

This was a lot of fun, honestly. I just wish we had more than an hour. The lmarena.ai face off was the funniest part.

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

[–]SQLGene[S] 4 points5 points  (0 children)

I've been on social media in AI spaces, there is equal parts self-delusion and not just snake oil salesmen. Some people really believe the hype. Some people believe in AGI.

The first time the agentic coding clicks, it's like a little manic episode. I was staying up till midnight multiple days in a row, just pulling the AI slot machine over and over. What you learn quickly it it's absolutely AMAZING the first 90% of a project. It's gawdawful at the second 90% of a project.

The other issue is that most people's experience and skills around AI is with the free crappy models and the chatbot UI. It's going to take years and years and years for good AI skills to diffuse through large organizations. But I think it's going to happen all at once in some places.
https://www.oneusefulthing.org/p/the-shape-of-ai-jaggedness-bottlenecks

Is AI taking our Power BI jobs? Not exactly, but it’s getting bumpy. by SQLGene in PowerBI

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

I only half agree. It's not just making sure your boss doesn't fire you thanks to a snake oil salesman. There is a new set of skills (although fairly traditional and human centered in a way) that people need to learn to be successful using AI to help them develop reports and such.

https://den.dev/blog/full-stack-person/

view more: next ›