This post is a space to highlight a Fabric Idea that you believe deserves more visibility and votes. If there’s an improvement you’re particularly interested in, feel free to share:
If you come across an idea that you agree with, give it a vote on the Fabric Ideas site.
I want to start learning Power BI, but I wanted to ask: do companies prefer official courses like PL-300, or is simply learning from YouTube enough?
When I use naturalinnerjoin it shows this error.
The column with the name of “CustomerID” already exists in the “Table” table.
How do I fix this?
Does anyone know of any Power BI weekend bootcamps in the Atlanta area?
So, I'm in a weird project. The company I'm working has 6 distinct servers on AAS hosting models for Power BI reports, some reports are Imports but some use Live Connection, and I cannot understand what its the advantage of having an infrastructure like this.
My current project is to reduce the cost that this servers are generating (all of them are in the price tier S4).
Besides that the refresh process for these servers is a mess. Its all through runbooks that have a million different schedules. The Live Connection reports compete for the resources of the server when they are in use and generate a lot of memory issues on a capacity that is already fairly high.
I'm here trying to come up with a plan, but this seems so complicated. I've not personally worked with AAS before. So my first instinct is to convert all these "live connection" reports to imports, they refresh like 3 times a day with the runbooks, there is no "real time" data or anything.
How would you approach this issue?
Our Power BI inventory dashboard currently depends on manually exporting data from Oracle WMS Cloud (LogFire).
We have access to the WMS application but not the underlying SQL database.
From an enterprise architecture perspective, what would be the most secure and reliable way to automate this data flow and keep the dashboard updated with minimal manual intervention?
I’d also appreciate advice on how to present and justify this requirement to our IT department while addressing security and system-performance concerns.
Hi everyone,
I'm working on creating a standard Power BI theme that my team can use across all of our dashboards. The goal is to provide a consistent experience for users so that reports feel familiar, professional, and easy to understand regardless of who built them.
My biggest challenge right now is color selection.
Our primary brand color is a bright red (#C91245), but when I use it heavily throughout a dashboard it feels overwhelming and visually harsh. We also have several supporting brand colors available, and I'm trying to determine which colors should serve as primary, secondary, and accent colors within the theme.
I'm also debating between:
One complication is that many of our reports contain 20+ reason code categories that need to be displayed in charts and visuals. My current palette doesn't provide enough distinct colors, so Power BI starts assigning default colors, which makes the dashboards feel inconsistent and cluttered.
My goals are to:
These are the brand colors I have available:
If you were building a dashboard theme around these colors, how would you approach it? Which color would you use as the primary color, and what strategy would you recommend for handling visuals with 20+ categories?
I'd love feedback from anyone with a strong eye for dashboard design, data visualization, or color theory.
Which course do you recommend taking?
I have cleared pl300 how can I find a job in this sector please someone guide me i really need some good advice.
Is anyone facing issues with deployment pipelines. We have been using deployment pipelines regularly and all of a sudden deployment pipeline sync has stopped working correctly and is always showing out of sync for a specific semantic model.
We have a DEV -> UAT -> PROD setup for deployment pipelines.
There are no deployment rules changes. The only thing recently changed is that we added a new source table.
In fact the table is actually visible in the PROD workspace as well, changes are there and I can query the table in PBI service as well.
Despite multiple deployments from dev to uat and uat to prod, successful deployment doesn't result in code sync.
Thanks in advance.
First try. Got a 718.
Suuuuper pumped. Started using power BI about a year ago at my current role with only Salesforce experience. It was an eye-opener in a big way.
Had my second kid recently, and that made studying pretty difficult. So I’m excited to pass it on the first try and be done with it.
I used datacamp classes and the MS text exam. Datacamp is great but doesn’t prepare for the exam really. But it’s great for learning.
Are you using MCP with client data and/or sensitive business data in general?
For my own projects I’m using Claude throughout the development process but not sure I will be able to for client data.
Would, of course, love to be able to do all dev via MCP as standard now, but feel like it would be challenging to convince clients.
Doesn’t help that I don’t have a good grip of the security of connecting Claude to a semantic model. As I understand it, it doesn’t see raw data as such, but in theory can query at will. At best, it’s then training with that data and at worst, there could be a breach at some point.
What are people doing?
Joined a new org and they do all their development in power bi service. ETL and the semantic models are done through fabric notebooks but the construction of the visual layer is all in the service. I’ve been using power bi for years and have never encountered this. Every org use desktop to a certain extent, anyone seen this before
Hi
I am in the middle of creating an office utilisation / attendance dashboard and wanted to include a heatmap calendar visual that shows the days the office is used the most, with the option to then filter by individual to view the days they went into the office.
I found a Calendar Heatmap visual by DataViz which does exactly what I want:
It looks great in PowerBI desktop: (click the image to see the real quality)
But when you publish it to service the quality drops drastically: (click the image to see the real quality)
Thanks
I created a numeric parameter that goes from 1 to 2,000, but when I try to filter using certain values, such as 8 or 10, they simply don't show up as options.
I've already tested it on a separate page with no filters or other visuals affecting it, and it still refuses to show some of the values.
What's even stranger is that when I use "See as a table", it only shows the values that I'm actually able to select in the filter.
(there are no filters on the visual nor the page)
I've worked with numeric parameters before and have never run into this issue.
Has anyone experienced something similar or knows what could be causing this?
Please make me understand why this is deemed a good language convention.
I'm trying to pull data from multiple sources into a dashboard but not all of the data has connectors for PBI. My gut reaction is to just pull it all into an Excel sheet but that's a bit of manual labor for up keep (unless I script it and run a GitHub action). Would a lake house setup be more ideal? I feel like I'm missing something.
Note: I work for a large corporation
Hi everyone! I’ve been working with Power BI for around 2 years and I’m comfortable with the basics of dashboard development, DAX functions and data modelling concepts like star schema, relationships, fact tables, etc.
However, I’ve relied heavily on AI tools like ChatGPT and Claude especially for DAX and modelling. Tight deadlines pushed me into this habit and honestly, I never felt the need to learn things deeply.
Now I want to change that. I’m planning to take the PL-300 within the next 3 months and actually build a strong foundation instead of depending on AI.
My organisation provides free Udemy access. What courses/materials would you recommend and how should I approach my preparation given my current level?
Please don’t judge 🙂 I know I took the easy route, but I genuinely want to improve and prove myself.
How have you tackled the “Can I get all of this in one place?” question from an exec?
I have multiple apps that correspond mainly to subject matter, but sometimes access level. For example,
- Accounting App
- HR App
- Marketing App
- Executive App
- Misc Department Apps
This guy has access to just about all of them but he doesn’t want to have to click from one app to another I get why it’s annoying, but what really can be done other than just publishing in multiple different workspaces and ensuring proper source control.
Have any of you run into this and had a good solution?
I've been using Power BI writeback since day 1. And to be completely honest, I wish I didn't have to.
It is extremely basic in what it can do UI/UX-wise, and as soon as there are extra requirements, you start fighting both Power BI and DAX to make it work.
It doesn't get any better when you have to deploy it - remapping all the entities manually because deployment pipelines don't do that.
I've been super excited when it first got released, and extremely disappointed the longer I use it.
This is where Fabric Data Apps (Rayfin) come in.
• Native integration with Fabric SQL DB - check.
• Flexible web UI - check.
• Accessibility for AI agents - check.
• Ease of deployment - mostly check.
You can prototype a working MVP in minutes. And with so many web components freely available, you can get a polished, fully customizable UI without having to fight Power BI conventions.
It's not all roses though.
Since these are React web apps, you're now responsible for the UI stack - monitoring performance, keeping dependencies up to date, and all the other fun stuff developers get to deal with once you move the UI stack from something Microsoft supports into the hands of developers.
And despite all of that, I'm hooked.
YouTube video: https://youtu.be/O2RAWlrLlSk
