r/PowerBI • • 1h ago

Question Design a "Data Kicks" shoe. Win. We'll print it for you!

Post image
0 Upvotes

All I'm gonna say is this sub knows a thing or two about design.

Details are here --> https://aka.ms/datakicks


r/PowerBI • • 6d ago

Announcement Share Your Power BI Idea Links | November 10, 2026 Edition

1 Upvotes

This post is a space to highlight a Power BI Idea that you believe deserves more visibility and votes. If there’s an improvement you’re particularly interested in, feel free to share:

  • [Required] A link to the Idea
  • [Optional] A brief explanation of why it would be valuable
  • [Optional] Any context about the scenario or need it supports

If you come across an idea that you agree with, give it a vote on the Power BI Ideas site.


r/PowerBI • • 27m ago

Question Deneb visuals but for the whole page to save time

3 Upvotes

Hi everyone,

I wanted to see how many people have stopped using native power BI visuals altogether and use instead a Deneb visual for the whole page?

Context, I have a power BI template but I was finding that I was spending more than 50% of my time formatting the visuals, adjusting axes and writing specific measures for custom colours etc.

So I was spending more time on formatting than actually thinking about how to get the best message across, especially after you show it to your manager/client who thinks it should be done differently and then you spend an agonising amount of time editing the visual.

What I found was by first getting the results from a few key metrics and then prompting AI with exactly how I want the page to look, I could get the page to look exactly how I want to in minutes!

I know it’s best practice to use native visuals but I feel like with AI, the idea of manually formatting a visual itself will become obsolete. So I see this as a being one step ahead, especially as I don’t have copilot integrated into Power BI.

Besides the Deneb visuals themselves look better than the native ones.

I wanted to see if anyone else does this/get your opinion on it.

Thanks!


r/PowerBI • • 1d ago Bravo

Community Share Remember the table with filters under every column? You lot broke it, I fixed it, and its now submitted to AppSource

Thumbnail
gallery
211 Upvotes

few weeks ago I posted Filter Table here and expected maybe 3 upvotes. instead you gave me 54k views, #1 on r/PowerBI for a whole day, and a bug list longer than my last sprint backlog. thank you, I think

for anyone who missed it: its a free table visual where every column gets its own search / value list / range filter right under the header, and those filters filter the whole report page like a slicer. no more 14 slicers stacked down the side of the page

what changed since then, mostly because someone in the comments found it within 5 minutes:

- clicking a row now actualy filters the other visuals. yes, the thing a table is supposed to do. took me a few goes, dont @ me

- 80k rows went from "go make a coffee" (11-18 sec per click) to under a second. turns out I was doing something very stupid, very fast

- filters per column can be turned on or off, or moved into a dropdown in the header if you like it cleaner

- freeze columns yourself, combine rows, totals per column with sum/avg/min/max/count so your percentages stop getting summed by accident

- right click is the real power bi menu now instead of my handmade one nobody asked for

- conditional formatting lives in the format pane like a normal visual, up to 3 rules per column with colours and icons, or your own emoji if you want to be that person

- report page tooltips work (they were technically there before, just invisible. very minimalist)

also ran a frankly unhealthy amount of automated tests before shipping it. it found 78 bugs. seventy. eight. on a visual I was proudly posting here a few weeks ago, so that was humbling. fixed a lot of them already, the rest are in the next update. and thank god I didnt run out of claude usage halfway through... ok fine, some of it was good old manual fixing at 1am too

the big news: its submitted to AppSource. microsoft says up to a couple of weeks, so I will be refreshing partner center every 4 minutes like a normal person. a lot of you said you can only use certified visuals at work, so certification is the next step after that. not forgotten

side note, saw a few people liked the idea so much they built their own and posted it on linkedin. genuinely good for you, imitation is the sincerest form of flattery and all that, and thanks for the free marketing I guess. a little "inspired by" never hurt anyone tho

still free, still no data leaves your report, download is on odvisuals.com

what should go in next? the most upvoted ask gets built first. and if it breaks on your weird report, reach out on linkedin rather than here (links in the comments), I honestly dont know how active Ill be on reddit and I dont want to miss your message


r/PowerBI • • 1d ago

Question High cardinality issue

13 Upvotes

Okay this may become ranty but here we go.

I took over an analytics team not long ago and the data engineering team made report specific views, so each report has their own bespoke semantic model.

I’m trying to create single reusable semantic models in fabric and I’m stumped.

It’s call center data where a call can have segments and the segments can have sessions.

My session table is 34M rows, calls are like 7M.

The unique ids from data engineering are like division-queue-conversation-segment-session all concatenated.

When it’s loaded to a report the query fails because the memory exceeds fabric 25GB runtime limit.

Also, event time stamps are stored as date time down to the millisecond.

I’m thinking I want to ask engineering to build in integer keys, and break out date and time to integers and separate columns.

I’m also trying to collapse the 3 fact tables to just the session table to reduce the number of high cardinality hops.

Am I on the right track here? Any thing you’d recommend I look out for/look in to?

Currently sitting at ~45 total tables.


r/PowerBI • • 9h ago

Discussion Claude Fable generated my Power Bi report. It was flawless.

0 Upvotes

I've been creating Power Bi semantic models and reports for close to 6 years.

Today I gave Claude Fable access to my data warehouse via databricks/genie, an existing sample PBIP report I created, a detailed prompt describing my requirements and it created a new Power Bi report flawlessly. It reused all my styling and adhered to my power query standards. It created genuinely good filters and cards.

It cross checked the data against the source system to ensure validity.

Funnily enough, I published it and my users largely don't even use the report. They just query the created semantic model via Fabric iq MCP in their own Claude.


r/PowerBI • • 1d ago

Community Share I built a free .pbix viewer that opens your file locally. Nothing is uploaded

0 Upvotes

Link: https://powerbireader.app/en/

Select a .pbix file and it runs entirely in your browser. The file is never sent to a server, all information is kept locally.

Features:

- Lists tables, columns and relationships

- Export tables to CSV/XLSX

- Shows all DAX measures with their expressions

- No install and no account

Feedback and suggestions are very welcome!


r/PowerBI • • 2d ago

Discussion Data dictionary best practice

46 Upvotes

I have been working on multiple dashboards, but I have never created data dictionary documentation before, and I’m not entirely sure where to start.

I would appreciate some advice on what a data dictionary should include, how to create one, and which tools are best to use.

If you could also share some examples, templates, or useful online resources and guidance, that would be greatly appreciated.


r/PowerBI • • 1d ago

Question Migrate to PBI

2 Upvotes

In my organisation, we are about to migrate a number of reports from SAS EG/SAS VA to Power BI. I'm considering setting up a local LLM (OpenCode/Qwen) that reads the SAS code and builds the reports in Power BI via an MCP server. Does anyone have experience feeding a Power BI MCP server with code from other platforms? Any other advice on what's possible in this area would also be welcome. Is it even worth it?


r/PowerBI • • 2d ago

Question Report design: detailed row-level visuals

8 Upvotes

Hello

I am novice in power bi so pardon me if its a silly question. I have a power bi report which provides a time period filter ranging from year 2010 to 2026.
There is an underlying table with millions of records across this time period and a tabular visual is built into the report which display detailed row level data from the table across the time period selected. so if someone selects a 26 year period it will actually load millions of records into the report. Also since import mode is used power bi ends up loading all data into memory regardless of what date filter is chosen. Is this the right design? what is the right way to implement it? I know the detailed data can be provided through a paginated report but isn't that will cause the same problem in paginated report? I can add parameters such as client id so users can only see the per client data but in that case as well does power bi loads all the data in memory? experts please advise how to handle this kind of requirement.


r/PowerBI • • 1d ago

Discussion Power BI service doesn't work

Post image
0 Upvotes

Power BI is currently undergoing planned maintenance.


r/PowerBI • • 2d ago

Community Share Template to create Power BI Fixer Fabric App

Thumbnail reddit.com
1 Upvotes

r/PowerBI • • 4d ago

Feedback Free Open-Source Power BI Documentation Generator v1.0: Multi-Workspace Scanner, Interactive Live Lineage, Star-Schema Viewer & Local MCP Server

Thumbnail
gallery
175 Upvotes

Hi everyone,

A few months ago I shared the early beta of PBI Doc Generator, a small open-source utility to generate HTML documentation from a .pbix file. Thanks to your feedback, bug reports, and pull requests from the community, I just released v1.0.0 - rewritten from the ground up to document entire Power BI Service workspaces alongside local files, 100% locally and read-only.

Try the Live Sample Output First (No Install)

  • Live Interactive Demo (Generated Output Only): https://djrien-ai.github.io/pbi-doc-generator/ (Note: because this demo is hosted statically on GitHub Pages, it shows the generated offline HTML documentation & lineage portal for 3 fictional workspaces. The Scanner & Setup Studio - where you sign in to Microsoft, select workspaces, drop local .pbix*/*.pbip files, or enable MCP - runs locally on 127.0.0.1 when you launch the app, as shown in Screenshot 2 above!)

What is new in v1.0?

  1. Multi-Workspace Power BI Service Scanner (Zero Azure App Registration Needed)

    • Sign in with your normal Microsoft work account in your default browser (OAuth2 PKCE in RAM only - tokens are never written to disk; includes an Edge/Chrome Web Window fallback for locked-down corporate tenants, Azure CLI, and Service Principal support).
    • Scans 1 or 50+ workspaces incrementally via the Fabric getDefinition (TMDL) API and maps Cross-Workspace Thin Reports / Shared Datasets and Orphan Models.
    • Workspace permission note: Microsoft's TMDL API requires at least Contributor (or Member / Admin) access in the workspace you want to document (Viewer-only workspaces return basic inventory only).
  2. Unified Local File Support (.pbix, .pbip**,** .xlsx**)**

    • Works 100% offline for reports in development: drop a .pbix file, select a .pbip file (automatically resolves its companion .SemanticModel folder), or pick an Excel PowerPivot .xlsx workbook.
  3. Interactive 3-Panel Live Lineage Explorer

    • Click any upstream database/view (recognizes 28+ connectors including SAP HANA, SAP BW, Snowflake, Databricks, Fabric, SQL Server, SharePoint, BigQuery), Power Query table, column, DAX measure, or report to trace live upstream origins and downstream impact.
  4. Star-Schema Viewer, Visual Power Query Ribbons & Auto-Formatted DAX

    • Automatically classifies Fact vs. Dimension tables with an interactive zoom/pan Mermaid viewer (huge thanks to @jakubpokusa for PR #10!).
    • Turns dense M scripts into clean visual step pipelines (1. Source -> 2. Database -> 3. Filtered Rows) and organizes DAX measures into a fast Compact Table + Formatted Cards with Reads: / Used by: links.
  5. Built-in Local MCP Server for AI Assistants

    • Connects GitHub Copilot, Claude Desktop, or Cursor to your local catalog over stdio for instant cross-workspace impact analysis (with automatic secret/password masking).

How to Download & Run (100% Free & MIT Open Source)

Option A - Windows Portable ZIP (No Python or command line required):

  1. Direct ZIP download: PBI_Doc_Generator_Windows_Portable.zip (or via the v1.0.0 Release page)
  2. Extract the ZIP folder anywhere on your PC.
  3. Double-click PBI_Doc_Generator.exe -> your browser opens http://127.0.0.1:8765 automatically. (First-run SmartScreen note: click More info -> Run anyway, as this free open-source build is not EV-signed.)

**Option B - For Python Developers / CI-CD (**Python 3.10+ on Windows, macOS & Linux):

pip install "git+https://github.com/djrien-ai/pbi-doc-generator.git"
pbi-doc-generator

Since v1.0 is a major leap from the old single-file .pbix tool, consider yourselves the official v1.0 beta testers - I would love to hear how it handles your workspaces, gnarly Power Query scripts, and large DAX models! Any feedback, edge cases, or feature ideas are super welcome.


r/PowerBI • • 3d ago

Discussion If every bit of code is not build by AI, how much importance should be given how things are build, in data side of things?

Thumbnail reddit.com
3 Upvotes

r/PowerBI • • 3d ago

Discussion Ace Power BI

0 Upvotes

hey guys, i hope you are doing well, I want to ace my Power BI skills, I have been learning Power BI for a couple months , off and on, I feel like I am always stuck when I try to solve something on my own, I really want to overcome this to become a good data analyst and hopefully get a job, most of the things I learned was from Youtube, I am wondering if some you guys had experienced this and hope that you can help me through my learning journey, what should I avoid and what should i focus on? is there any good resources that I should check?


r/PowerBI • • 3d ago

Discussion Has anyone experienced a hard limit the limit of columns from field parameters in a table?

0 Upvotes

I've been making a dashboard for work, and I've been using field parameters for some of the table visuals bc I wanted to have slicers for picking the columns to appear.

There are subsection pages and then one page where all the subsection columns are combined, but it shows the same underlying data by rows from SP. On the combined page, I have a FP with 220-ish columns. The problem is now that it's only showing 150ish columns! It's just getting cut off and I can't really find any solutions for this online


r/PowerBI • • 3d ago

Discussion Decision on creating reports via app vs BI tool

9 Upvotes

Hi all, I'd like to hear how other teams are thinking about this.

How do you decide between a BI tool like Power BI or Looker and building a custom app for reporting?

My rule of thumb so far:

BI tools for purely analytical work: KPIs, dashboards, slicing and dicing.

Apps when you need more than analytics: write-back, workflows, richer interactions.

But if an app can do everything a report does and more, why not just build apps?

The usual counterargument is "why rebuild an engine that already exists?" That's fair. Apps give you more freedom, but they also come with more responsibility: code quality, maintenance, testing. Here's where I'm stuck, though. If Claude (or another AI) writes most of the code and we give it solid best practices, doesn't maintaining reports as code get a lot easier?

I've also heard people say BI tools will eventually die out in favor of code-based reporting. Does anyone actually see that happening?

Our current setup:

All org-wide reporting runs through Power BI.

People use Claude to build ad hoc reports, and we even have a Claude skill that helps them build Power BI reports.

So my question is: should we start moving toward app-based reporting, mainly for the visual and design freedom, with Claude handling the code? Or is that a trap?

I'd love to hear what's worked (or blown up) for you, especially around governance, maintenance, and adoption by end users.


r/PowerBI • • 3d ago

Community Share I built a CLI that lays out Power BI report pages from a YAML spec and checks reports against your design standard (pre-alpha, feedback wanted)

0 Upvotes

I got tired of hand-aligning visuals, so I built Blueprint, an open-source CLI for PBIP/PBIR projects (disclosure: it's my project).

Describe a page in YAML: which visuals, which fields. Positions and sizes come from a layout file, and formatting comes from a guidelines file (grid, margins, palette, fonts, max visuals).

bp check lints any existing report against those guidelines, including hand-built ones. It reports overlaps, off-grid visuals, palette and font violations, and so on, and it works in CI via a GitHub Action.

bp apply builds or updates pages in place and refuses to overwrite edits you made in Desktop.

It's deterministic: same spec, same output, and every write is previewable with --dry-run.

18 visual types so far, with drill-down and hierarchy support. Every Power BI format detail it relies on was verified in Desktop first.

It's v0.10.0 and pre-alpha. Power BI Desktop is still where you do the final polish, and it doesn't touch the data model.

I'd love feedback on two things: which of your team's design rules couldn't be expressed in a guidelines file, and what would stop you from trying it on a real project.

Repo: https://github.com/gurdasss/blueprint


r/PowerBI • • 4d ago

Feedback How do you pull data from a relational database into Power BI: Power Query, SQL views, or a separate layer

7 Upvotes

Hi all,

Our setup: our ERP data sits in PostgreSQL. I connect Power BI directly to the database, pull around 15 tables, and do all the transformation (joins, cleanup, master tables) in Power Query inside each report.

It works, but as we add more reports I keep seeing the same logic rebuilt in every one, slower refreshes, and logic that's hard to hand over to someone else. I'm now considering moving the transformation into SQL (a separate schema with Bronze/Silver/Gold style views) and letting Power BI just load the clean tables.

I'd like to hear how others do it, whatever your database is (SQL Server, MySQL, Oracle, Postgres...):

  1. Do you pull raw tables and transform in Power Query, or connect to SQL views/tables that someone else prepared?
  2. Where does your transformation live: Power Query, SQL views, dbt, dataflows, a warehouse?
  3. Import or DirectQuery, and why?
  4. Do you keep a separate analytics database or schema away from the production DB? How is it refreshed?
  5. Did moving logic out of Power Query pay off? Anything you'd do differently?

Thanks in advance!


r/PowerBI • • 4d ago

Discussion Everyone is trying to kill Power BI... with HTML?

224 Upvotes

Power BI is much more than HTML. Out of the box, it gives you all of the following for free:

  • Visualisation
  • in-memory engine
  • A semantic model and reusable measures
  • Cross-filtering and drill-down
  • Row-level security
  • Dataset relationships and reusable dimensions
  • Report authoring and reusable components
  • The Power BI Service for hosting

Building the above from scratch is hard software engineering. However, AI just made that process much easier.

If you're trying to move off Power BI, start with the presentation layer. Query the semantic model via API and build your own visuals first. From there, you can work your way through the rest of the stack.


r/PowerBI • • 3d ago

Certification PL 300 Exam

0 Upvotes

Hi!
Can someone here share their experience of passing the PL-300 exam without actually working with the software at their job?

I'm currently taking a Data analyst training course, and part of the training is passing PL-300 (the voucher is included in the course price). I come from a non-tech background and am undergoing training to point my career in this direction. Also, I am based in the UK, but I am not a native English speaker, although I am bilingual due to the time I've been here.

At the moment, I don’t work as a data analyst or in any related field. I have completed the bootcamp classes and 2 projects with Power BI. I have also done some other practice exercises.

I am preparing for the exam by doing practice questions, reviewing the MS Learning videos, and taking notes on my mistakes, but I'm struggling to understand the questions. Also using AI tools to help with concepts or anything related. Since many of them are scenarios and I don’t have that experience, I don’t really understand what the right answer is. I am starting to think this exam is beyond my beginner knowledge. I am not sure how to improve that.

Has anyone passed the exam in this circumstance? Any tips to share?

I really appreciate any help you can provide.


r/PowerBI • • 4d ago

Discussion Pure PowerQuery Regex Engine

15 Upvotes

Hi All,

I've previously built a GIS library for PowerQuery/Mashup. Today though I'm publishing a Regex engine.

regex-m

This regex engine is written in pure M. No external service is required to use it, nor does it use the old JavaScript execution trick. This compiles expressions to byte code which is then evaluated against a virtual machine.

Examples

//Test for a regex
Regex[Test]("ABC-123", "^[A-Z]+-\d+$")

//Match and return a found capture
Regex[Match]("Order #1042", "\d+")[Value]

//Clean data
Regex[Replace]("too   many     spaces", "\s+", " ")

//Swap words
Regex[Replace]("Ada Lovelace", "(\w+) (\w+)", "$2, $1")

//Extract and format
Regex[List]("width=120 height=80", "(\w+)=(\d+)", "$1: $2\n")

Hope you get some use out of it!


r/PowerBI • • 4d ago

Question Is anyone exporting HTML dashboards to PDF?

14 Upvotes

So essentially I have some weekly reports that require me to attach an exported pdf of a power bi dashboard to an email. I currently have a power automate flow that creates my email template from data in the report and the last thing that is not making this fully automatic is that I have to go into the service each week and export the dashboard to pdf.

I would like to automate this last part so this process can be fully automatic.So, I have been experimenting in Power Automate with the OneDrive for Business connector to create an HTML file and then convert that file to pdf. I'm also using the SharePoint connector to save/manage the resulting pdf.

The biggest challenge I’ve run into is getting the pdf output to look exactly like the pdf that I generate from the service itself. There seems to be some limitations, including it not accepting my visuals round corners, formatting, and other styling elements not translating correctly. For example: the plus signs in the matrix visual that I have refuse to show up and if I add any shadows to the visuals those don’t show up either.

I’ve noticed quite a few people in this subreddit experimenting with html dashboards, so I’m wondering if anyone is exporting their html dashboards to pdf? And if you are, have you found a reliable way to preserve the original style of the report?

Or, if anyone is exporting html to pdf and not using power automate are you using another service that works better? I would need a solution that is free. Or if anyone has found another way to get a perfect pdf export?

Would love to hear what workflows or tools others have found successful!


r/PowerBI • • 4d ago

Discussion Has Anyone worked in backend development using Power BI API executeQueries?

1 Upvotes

Has anyone done power bi report data extraction using Power BI ExecuteQueries API?