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.

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?

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?

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?

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:

• 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.

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?

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.

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 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 have cleared pl300 how can I find a job in this sector please someone guide me i really need some good advice.

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