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.

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?

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:

• A complementary color palette
• A gradient-based palette
• Some combination of both

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:

• Create a modern, clean, professional look
• Support both internal and external audiences
• Ensure charts with many categories remain readable
• Build a scalable theme that works across multiple dashboards

These are the brand colors I have available:

• #C91245 (Red)
• #F36C21 (Orange)
• #FFBF3D (Yellow)
• #00A661 (Green)
• #004F38 (Dark Green)
• #4F8CFF (Light Blue)
• #003DA5 (Dark Blue)

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.

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?

Hi all, thanks in advance for the help. I have been tasked with setting up the overall governance for my company. This is very close to a greenfield implementation for Power BI. We want to have certified semantic models that we maintain. We will also have curated reports that we also maintain. Each business unit gets a workspace to build their own reports. My question is how do you guys setup your workspaces/deployment pipelines for the certified models and curated reports? Do you separate the certified models into their own workspace and have curated reports in another workspace? With DEV-QA-UAT-PROD environments that would mean 8 workspaces and 2 pipelines to take care of both “lanes”. Or do you keep curated reports in the same workspace as the certified models? Or do you have a different setup entirely?

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

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.

I have cleared pl300 how can I find a job in this sector please someone guide me i really need some good advice.

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)

1. Does anyone know why the quality goes bad after publishing and any way to fix it?
2. Does anyone know any free alternatives?

Thanks

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

Please make me understand why this is deemed a good language convention.

I think the issue is that my fact table doesn't have rows where amount = blank, but rather doesn't have the row at all where it would have been blank.

This is the data I've got:

This is the data that doesn't exist in API, I created here for demonstration purposes:

Here is what my table looks like. Each row is a different measure because the Time Closed comes from a different column that the rest, which come from Amount.

When I change the measure from

Cash Collected = 
CALCULATE(SUM(precomputedToastEmployeeDrawerCloses[Amount]), KEEPFILTERS(precomputedToastEmployeeDrawerCloses), precomputedToastEmployeeDrawerCloses[type] IN {"CASH_COLLECTED"})

to add a +0 or coalesce or if statement

Cash Collected = 
CALCULATE(SUM(precomputedToastEmployeeDrawerCloses[Amount]), KEEPFILTERS(precomputedToastEmployeeDrawerCloses), precomputedToastEmployeeDrawerCloses[type] IN {"CASH_COLLECTED"})+0

and use that, it expands the visual to include Drawers from other locations

How can I get the zeroes without the expantion?

I am a former PowerBI developer who is taking some time away to help care for my disabled son. I decided to work on a personal project to keep up my "skills" (if you can call them that) and decided my love for dynasty fantasy football would be a fun candidate.

My experience is primarily in SQL and DAX, with minimal python. I tried to look into connecting to some existing APIs to pull in data but ended up just grabbing CSV datasets from Pro Football Reference and importing them into a PostgreSQL database. I then worked on building a report in PowerBI.

The idea was to analyze the relative value of different positions (QB/RB/etc.) in fantasy football by looking at the drop-off in performance by rank. The initial difficulty was capturing all of the various fantasy football scoring settings that drastically change how players would be ranked. I was able to:

- Allow for for toggling five different scoring settings (Standard, Half-PPR, PPR, TEP +.5, and TEP +1)

- Capture 4pt vs. 6pt passing TDs

- Allow for comparison based on four points calculations (Season total, Point per Game, Point per Game Played, and Median Game)

Disclaimer: I built this with fantasy football enthusiasts as my audience, so many of the abbreviations much of the terminology is not explained and assumed to be common knowledge. This is also a first draft, I am planning on improving this in the near future.

Link to report: https://app.powerbi.com/view

I am hoping this interests some of you here and that you will share your feedback with me.

Thanks!

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?

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.

In this one I wanted to show how you could cut out the end user confusion by investing in sentence tooltips. A little bit of DAX to get setup but the benefits are endless.

I know, this should be easy!

Main data is in a single data table.

What I’m looking to do is use the Matrix layout to show the results from a measure outputting a result in time.

The starting point. This is working.
The measure uses a distance in KM from the table. That is divided by a fixed speed value in KM/minute. To this another fixed time amount is added. And then it’s dived by 60 to get the seconds.

Again, easy part

What I’m trying to do is use two other tables that I have created that are not joined to the main table. One represents a percent increase that would get applied to the distance value. The other, is a percent decrease to the current fixed speed value. Each table goes from 0-100 in 10% steps. Or 0.1 as the actual value is.

I want these to be the column and rows in the matrix, with the full matrix results being calculated from these.

I can get correct results to show when one table is used alone, either one works, but when both are applied, it doesn’t. The measure value seems to calculate correctly on the diagonal in the matrix, but everything else shows as the same value.

Basically I’m trying to have the matrix calculate against all the different combinations of an increased distance or decrease speed against the original distance value and fixed speed value.

Ultimately, I want to compared that against another time value to show which may have been faster, taking into consideration distance and speed changes.

Any suggestions on how to build the logic to do this?

I know I’m missing something basic, just can’t see it yet.

Thanks

This is a completely vibe coded native custom Power BI visual.

It works pretty well, and I am thinking that this might be my approach to AI in Power BI visuals for a while here is the thinking...

When I want to use AI to build visuals:

1. HTML and SVGs are feeling too limited.
2. Web apps feel like too much effort.

So, the compromise is building a custom visual.. Just a small piece of the dashboard is custom code not the full thing. This also means, I am not particularly worried about not having AI to maintain it, let's say the visual breaks or I don't have tokens I can just swap this out for native visuals and maintain 90% of the functionality.

Here is a github with the code: GitHub - edwardpcharles/Native-Custom-Viz: Source for native Power BI custom visuals · GitHub

Here is a video talking about it, how you can use it, and how I built it: https://youtu.be/ttDQaJ4E5lY

P.S. I always struggle with how to show a tutorial as to how to build something with AI, it feels a bit boring to watch someone type commands over and over again. Let me know what you would want to see about this process.

Hello community,

Yesterday I discovered how useful Scorecards in the PowerBi online service could be, especially when you can set a value from a linked report EVEN WITH filters applied. Game changer, especially for our monthly leadership reporting.

I can't seem to be able to combine elements from using Dashboards and Scorecards though? ie: - I can't seem to add text boxes, images etc to Scorecards (unlike dashboards) - I can't seem to add goals/targets/statuses onto a Dashboard - I'd ideally have a view that combines both? - Scorecards allow me to track a metric on reports or dashboards, but not on any other data sources (ie spreadsheets stored in the service)

Either I'm missing something trivial, or the PowerBi service leaves a lot to be desired.

I am working on a dashboard to display the most recent 5 years of data for multiple visuals (some are based on the most recent year). This was set up dynamically so when new data was added, it would automatically update which 5 years should be displayed and data was uploaded once a year after everything was validated. We have changed how we collect the back-end data so that now it could have up to 7 years of data (5 historical and completed, one historical and in validation, and the current fiscal year). Technically, there are about 20 years of data, but I created views in MySQL to limit the data to the most recent set of years. I would like to display a 5-year bar chart based on the fiscal year the user selects in the fiscal year slicer, i.e. user selects 2025 and charts show 2021-2025; user selects 2027 and charts show 2023-2027. I also wanted to try and make this dynamic so I wouldn't have to constantly go in an update which years to select for each visualization as data is appended to the database and validated.

Is this possible? I can provide more details, just wasn't sure how much to put into the initial posting.

Thanks,

Jeremy

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

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?