How would I create this sort of drop down hierarchy bar in a power BI report? This is for a weekly revenue report that gets updated weekly, my boss wants it so that her or whoever else uses the report can quickly go back to prior weeks and look at the data from then.

Hello all, with the July 2026 Power BI update introducing new APIs for managing Org Apps capabilities that Workspace Apps still do not have I’m starting to wonder what Microsoft’s long term plan is.

Do you think Org Apps are eventually intended to replace Workspace Apps, or does Microsoft view them as two separate solutions for different use cases?

Right now, they do not feel completely separate to me. The overlap seems significant, and the continued investment in Org Apps makes me question whether I should start planning to migrate our Workspace Apps sooner rather than later.

I’m curious how others are approaching this. Are you already moving toward Org Apps, waiting for more feature parity, or sticking with Workspace Apps for the foreseeable future?

Goal: Embed power BI reports on our departments Sharepoint page. We have the proper licensing to do so.

Issue: I’ve built our reports using custom canvas size (1920x1080). It looks like Sharepoint only allows for 6:9 or 4:3 when embedding.

Question: Is there a way I can embed without having to resize the reports or opt for embedding individual visuals? This seems like a silly issue that’s making me wonder if I’m missing something. Thanks in advance!

Hi! I am working to recreate a visual my org uses in tableau in PBI and I have mostly gotten where I need to be. I needed to add a column before the data table in the matrix that displays the 'target' for each question(this is survey data). I wound up just making a second table that had the questions and the targets and then laid it on top of hte original visual so that everything fit and looks nice. The issue is that if I or an end user clicks on the table (color coded part) anywhere it moves that to the top and hides the box with the questions and the targets. Is there a way to make this layer(denoted by the red bracket i drew like a gorilla) stays on top and is always visible regardless of if somebody clicks the data table on the bottom layer? Thanks in advance! If I explained that poorly let me know and I can add more context!

My company has Microsoft Copilot licenses for everyone, but unfortunately we don’t have Copilot enabled in Fabric/Power BI yet. That means I can’t use the embedded Copilot features for things like understanding my semantic model, generating DAX, or asking questions about my data.
I’m looking for alternatives that could help me bring AI into my daily Power BI work.
I vaguely remember hearing about GitLab (or maybe GitHub?) having some AI capabilities, but I’m not sure if that’s what I’m thinking of. More importantly, can any of these tools actually read and understand a Power BI semantic model, including tables, relationships, measures, and DAX? Or are they limited to just helping with code snippets that I manually paste in?
Has anyone been in a similar situation? What AI tools are you using with Power BI when Fabric Copilot isn’t available?

Hi,

My company is a research, scientific company, which wants to present research results on interactive dashboards.

There is currently no structure for this. The current idea is to have:

- 2 Power BI Pro licenses for report developers, permanent

- Around 10 Power BI Pro accounts dedicated to external clients.

Each client would receive one of these accounts for the duration of their project and results viewing. Once the project ends, we would remove that client's access, reset the account password, grant access to a new report, later assign the same account to the next client.

The reports would be embedded into SharePoint Online pages, and clients would log in only to SharePoint using the assigned account.

My questions are:

1. Is this licensing model compliant with Microsoft's Power BI licensing terms? Can they track this down, close our licenses etc.
2. Is reassigning the same licensed account to different external clients over time permitted?
3. Are there any recommended alternatives for this scenario, assuming we have a monthly budget of 300-400 USD, want to avoid Fabric, Power BI Embedded(no backend/web developers), or hundreds of licenses and accounts?

Aktuell betreuen wir mehrere renommierte Kunden und suchen erfahrene Expert:innen zur Unterstützung laufender Projekte in:

• ⁠Power BI

• ⁠n8n

Bei Interesse bitte melden per PN

What was your favorite tip? What is one I should include next time?

I was wondering if anyone experienced enough could help me since AI is useless when it comes to this.

I have one table (which is actually 3 tables combined trough relationships, but I should not mess with that) which contains the following columns:

Part number
Required date
Required Quantity
Delivery date
Delivered Qtt

I need to somehow end up with a table that consists of every unique date (both Required and Delivery) and LoB (Line of balance) status at that date.

The tricky part here is that this final table must respond to filters and adjust the LoB status based on what is filtered at the moment. So doing an overall LoB calculation in the main table won’t work.

Looking forward to hear any advice.

I can’t figure it out for the life of me so if anyone can help that’d be great. Thank you!

Note: The text was translated using AI, so please excuse any inconsistencies. Data was anonymized. Open to all feedback!

En mi informe, tengo una consulta a una tabla SQL en SQL Server:
let

Origen = Sql.Databases("ANON"),

ANON_BBDD = Origen{[Name="ANON_BBDD"]}[Data],

dbo_fact = ANON_BBDD{[Schema="dbo",Item="FACT"]}[Data],

#"Índice agregado" = Table.AddIndexColumn(dbo_fact , "Índice", 1, 1, Int64.Type),

Personalizado1 = Table.SelectRows(#"Índice agregado", each[fecha] <= Date.From(DateTime.LocalNow())),

Personalizado2 = Table.SelectRows(

Personalizado1,

each not (

([id] = "CB95D93" and [id2] = "909")

or

([id] <> "CB95D93" and [id2] = "909")

)

)

in

Personalizado2

Si hago un conteo general, en algunos casos pierdo filas completas sin motivo aparente (en SQL un COUNTROWS me da 72.335 y en Power BI 71753).

¿A alguien le pasa algo similar?

I created this Legal Case Performance Analytics Dashboard in Power BI for the FP20 Analytics Challenge #39. It analyzes firm performance, lawyer utilization, case outcomes, and client insights.

I'd really appreciate any feedback on the dashboard, visual design, and business insights. Thanks!

What do you think is the best LLM for Power BI? I have been using ChatGPT, and it's working great for me, but I wonder if Claude is better. Can anyone with more experience tell me what I should go with? Thank you in advance.

Status: Degraded | Reported: Jul 21, 2026 at 8:55 PM UTC

Power BI Customers in East Asia might observe latency in scheduled refreshes.

🤖 This post was sent from an automated and unattended service and cannot respond to questions or requests. For official updates, visit the Microsoft Fabric Service Status page.

Hey guys, I'm learning power bi from scratch and I'd love to know how to go on about this, even roughly.

I want to be effective enough that I can market this skill confidently one day. Any advice would be appreciated.

Hi All,

There is a workflow that involves 6 different excel files being combined into one. I am trying to automate the workflow, and I have a few questions:

1- Is it a good idea to create dbo table after DataFlow Gen2? We don't have a database yet because we don't have enough data (probably excel file of 2 years i.e. 24 files each with approximately 25-30 rows and 15-20 columns). If we store it as a table, we can use it for future database.

2- Right now, the Power BI report comes from a semantic model that has master files, but again the master files are month-wise and there are so many master files in the folder, which is connected to semantic model. Is it a good idea to combine monthly files (from now onwards) when bringing the files in DataFlow Gen2? Or keep files separate? For example, the files are: Master File 1 Month X, Master File 2 Month Y, Master File 2 Month X, Master File 2 Month Y, and so on.

3- Sort of continuation of point (2) - Master File 1 -Month X and Master File 2- Month X are combined later to give a full picture. Is it a good idea to combine File 1 by month in DataFlow Gen2 stage, and then combine Master File 1 and Master File 2 at table stage before it becomes part of semantic model?

I hope my questions make sense. I am also working on it the first time, and I want to implement best practices.

Hi,

My project procured premium workspace, and we are exploring the ways copilot is integrated in Power BI app and reports.

I wanted to know, how you guys are utilising it in reports / data models etc.. any specific features that highlights the importance of copilot?

hi can anyone share if PL300 expire , is it best to renew or retake new PL300 cert ? ty

How can you create a toggle for user to turn on and off tooltips that too often get in the way?

Sometimes i want them on, other times off. Surprised there is no native functionality

Oi galera,

Estou com um problema que é o seguinte: Criei 3 cartões novos (nada de cola e copia) e cada um é alimentado da mesma tabela, porém com filtros diferentes. Contudo, quando tento colocar o filtro para cada cartão, todos os demais mudam juntos. Como resolver esse problema de independência dos cartões? (Não sou experiente em PB e a IA não consegue me ajudar).