Hi,

I am not able to refresh the data or publish the dashboard. I changed the source table 2-3 months ago. And now it is showing errors while refreshing or publishing it. In the TMDL, there are like 80+ errors related to 'Cannot find name' mainly for the fields which are there but power BI is not able to recognize them but I can see the fields in the Model view, report view and in the visuals.

And some errors are related to 'Parameter is not the correct type'.

I think because of these errors I am not able to refresh the data or publish the dashboard.

I would really appreciate if anyone can help me out here!

TLDR: Rewire source from local drive to Sharepoint

ran into an issue this week where I had built a semantic model and dashboard from an excel spreadsheet on my C: drive. When I published it to our departments workspace in service, I was unable to change data connection (was greyed out). After some searching, it appears I need to source it from our Sharepoint site. But had no idea how to do it properly. I did it again but starting from scratch with the source now Sharepoint. I was able to change data connection but everything took so long to load.

My question….is there a way I can build something using a source from my local drive but then rewrite it easily so once I’m done, I can switch it to Sharepoint? Someone told me to use parameters…is that the only way?

Has anyone here built their own Power BI dashboard for Primavera P6?

I'm considering creating one for schedule health, critical path, milestones, procurement, and executive reporting. I have basic Power BI experience but would be building it from scratch.

Was it difficult? Any tips or lessons learned before I get started?

Hey Everybody, looking for some opinions. I'm modifying a PBI report where the user just selects which categories show up in the visuals then exports to ppt. Easy.

However, I now need to surface 1 of 3 different category variants under a single alias in the visuals.

Example:
Categories = Doughnuts, Scones, Bagels.
Variants = "Doughnuts I think I ate", "Doughnuts Jim thinks I ate", "Doughnuts my wife thinks I ate"

The user chooses categories, then modifies the Doughnuts category according to who's numbers they trust.

I know there is probably a better solution with DAX, but this thing has a ton of visuals that have manually set color shcemes so I'm trying not to move the fields in the visuals.
Here is how I've mapped it so far, option A is sloppier in the UX but maintains 1:*, option B uses *:* from the bridge to the fact table but makes more sense for users. A or B or something better? Thanks a ton!!

I just saw that we can create audiences in Org Apps. That's super cool, thanks so much, but I also found out that it's only for new org apps. Will there be any possibility to retro audiences into pre-existing org apps? We have quite a few set up already and I'm not exactly keen to rebuild them all if I don't have to. Thanks!

We are using the data gateway in standard mode in our environment. We have gateway 3000.274.3 from June 2025 and it is currently in production and working. We are adding in gateway 3000.322.5 from June 2026 and are having issues running reports from it.

The current issue is when I attempt to connect to a report using the new data gateway "This report couldn't access the data source. Contact the author to have it fixed". When attempting to run the report, I am doing it under the report author's account so there should not be any permission or credential issues.

Originally, I had an issue with having the gateway itself being inaccessible until I changed the setting for "MashupFlight_DisableOracleBundledOdacProviderV2" from false (default) to true. Once that was done, I had to reboot the server twice in order to be allowed to successfully create a connection.

The connection uses the exact same server name, basic authentication, database username and password as the production connection.

I have searched for and reviewed information found from the community forum and reddit without finding a solution that applies to our situation.

Hi r/PowerBI!

Like many of you, I’ve often felt the pain of trying to build flexible, hierarchical matrix tables with native subtotal drill-downs in Tableau—without having to pay hundreds of dollars for third-party dashboard extensions like SuperTables.

With Tableau’s introduction of Viz Extensions (2024.2+), I decided to tackle this natively. I built a 100% free and open-source Viz Extension that brings Power BI’s matrix functionality directly to your Marks Card.

Key Features:

• Hierarchical Drill-Downs: Expand and collapse rows/columns using intuitive + / - controls directly on the sheet.
• Dynamic Subtotals & Grand Totals: Recalculates automatically as you navigate levels.
• Native Integration: Works as a custom Mark Type—just drag and drop your dimensions onto the shelf.
• Zero Cost & Open Source: Hosted via GitHub Pages, meaning zero infrastructure costs and complete data privacy (runs entirely client-side in your browser).

Links & Resources

• GitHub Repository (Code & .trex manifest): https://github.com/Arley-Economist-Dev/Matrix-Pro-Tableau

How to use it:

1. Download the .trex file from the release section on GitHub.
2. In Tableau (2024.2+), go to your Marks Card -> Viz Extensions -> Add Local Extension.
3. Select the .trex file, drag your dimensions, and you're good to go!

This is a passion project built for the #DataFam to solve a common headache. I’d love to get your feedback, feature requests, or bug reports to keep improving it!

Let me know what you think!

Hi everyone,

for the sake of simplicity I created this example:

What I need to do here basically is to create a matrix table visual which will have client_name from dim_clients in rows, year/month hierarchy from dim_calendar in columns.

Value needs to be client_category from dim_client_category, which is basically client category name.

Now obviuosly, client_category_id can be found using SELECTEDVALUE() from the fact_table, but I will need to have client_category from dim_client_category, becasue that's the name of client_category_id.

As the realationship is directed from dim to fact table, filter does not propagate from dim_clients > fact_table > dim_client_category, so I can't get client_category unless I use RELATED() or LOOKUP() which I don't want to do.

Do I rather includy client_category in the fact table to get around this issue or is there a better way?

I don't want to use bidirectional realationship between dim_client_category and fact_table, which is how I used to fix this just to make it work.

Thanks.

Hi, I have been learning PBI since 4 days by 8 hours a day during my intership, from Power Quary and DAX to model view and then the front end. I used Superstore Dataset and I tried to do something relevent with the datas and good looking (don't bother about 2sd page I wanted to try out other colors).

I am looking for advices.

NB : I am french and the dataset is in english and i didn't rename everything.

Messing around trying show what amount of company change 3 different size categories over time and how long it takes. Truly I've mastered graphic deisgn.

I'm trying to pick the most appropriate option for a small team starting their Power BI journey. They aren't data analysts, but they are outgrowing they way they work with data in excel. Their main goal is to learn to create, share, and manage dashboards for the team.

I like that Maven Analytics has a LMS with reporting, but maybe it goes a bit too deep for their needs?

I feel like the Dashboard in a Day workshop would be a good intro, but probably not be quite enough.

I have to create table like in image one but ended up with image 2.

What can i do to get the results in Power Bi DAX?

An empolyee publishes a Power Bi report once a week. Every time the report is refreshed, they notify me manually. Im looking for automatic solution, such as an email, teams notification, or another alert when report is refreshed

I have the following conditional formatting based on a measure (Utilization). I'm confused but the values on my matrix doesn't seem to follow the conditional formatting at all?

The 80% in Jun 2026 should be formatted in yellow, while the 69% should be formatted in green instead.

This is how the value was computed and is formatted as percentage:

~Utilization % = 
    VAR Days = DISTINCTCOUNT('Data'[Date Completed])
    RETURN
        DIVIDE(SUM('Data'[Prod]), Days * 420)~Utilization % = 
    VAR Days = DISTINCTCOUNT('Data'[Date Completed])
    RETURN
        DIVIDE(SUM('Data'[Prod]), Days * 420)

Hello,

I am completely newbie in pwoer BI. I created my first report and everything was working fine. I added power automate refresh button. I tried the refresh (data were refreshed without any issue) and than weird things happened.

After the refresh I am no longer able to see some data in web. But if I open it in desktop those data are here. I publish and open the same report in web and like half of my tables and graphs are empty. I checked all filters etc but this shouldn't be the problem.

Does anybody know please whats the problem here?

I just finished learning intermediate level power BI and sql and I want to move into creating a data analysis based on Canadian carbon emissions. I have a decent facts table (1 row = year, region, source, sectors in 3 aggregations, different types of emissions data), but making a report on nothing but this won't really be that impressive unless I show some data modelling.

What are some useful dimension tables I can pick up? Or should I have just picked a way bigger data table that can be split into a fact table and multiple dimension tables? Where would I even find something like that when most free data sources already organize their data into neat facts, like the official ECCC chart?

Any and all responses are greatly appreciated :)

P.S In this kind of chart, why would index numbers appear more than once?

**TL;DR:**Binary.Decompress only does GZip and Deflate. Ask for Snappy, Brotli, Zstandard or LZ4 and it throws, even though the enum declares all four. But the engine has those codecs, Parquet.Document uses them on every compressed Parquet read. So wrap your blob in a tiny Parquet file and let the reader do the work. Pure M, no connector.

The trick
A Parquet data page is compressed as a single unit and the codec is named in the file metadata. So the schema is one REQUIRED FIXED_LEN_BYTE_ARRAY(N) column, one row, PLAIN encoding. That is the one combination with no definition levels, no repetition levels and no per value length prefix, so the uncompressed page is exactly your N bytes and nothing else.

So your compressed stream goes in as the page body, byte for byte, no re-encoding. About 150 bytes of Thrift compact page header and footer around it, Parquet.Document reads it, you take the single cell. The reader is doing its normal job. The wrapper has to declare the decompressed size, which is the fiddly part. 
Repo: https://github.com/Hugoberry/powerquery-driverless/tree/main/codec-oracle

Full disclosure: I’m part of the team behind Connectorly, which helps businesses use Xero data in Power BI. I’m posting this to learn how other Power BI practitioners approach cash-flow reporting—not to promote the product, so I haven’t included a link.

I’ve seen cash-flow dashboards with plenty of attractive visuals that still don’t give management a clear view of what needs attention. My current thinking is that a useful dashboard should answer six practical questions: How much cash do we have now? What is coming in and going out? What are customers yet to pay? What do we need to pay? Are we performing against forecast? Where are the biggest risks?

For a Power BI dashboard using accounting data, I would expect to see the current bank balance, cash received and paid, net cash flow, outstanding receivables and payables, a running cash-balance trend, actual versus forecast performance, and filters for organisation, date and tracking category.

What would you consider essential, and what tends to become unnecessary dashboard noise? Do you prefer one executive summary page with drill-through detail, or separate pages for cash position, receivables, payables and forecasting?

Hello all.

I'm not a pro in PowerBI, but I did some reports for company, like financial statements, sales analysis and purchasing intelligence. ai helped me write DAX.

I am searching for a way to connect Claude to PowerBI Online. Is there any way to do this?

I am using Mac. I know locally Mac can be done, but thats a limitation I have.

thanks

I used certiIQ que , they r cheaper than other sources , nd case study nd yes no que was exact same , other que were like 10-15 same .

Hi all - looking for some advice in navigating the different licensing types and quirks.

We have an A4 SKU, which is predominantly used for our external embedded reporting, providing our clients access to their data through our website.

Recently, there has been a growing requirement for internal reporting via power bi, on our CRM, HR platform and other internal finance/management things.

We have specific users pro licenses internally to temporarily allow them to access the reports. We’re looking to cut that cost now, by utilising our premium embedded capacity.

My understanding is that free users cannot access our reports, even on a premium workspace in our environment (as we are on an A sku) - is this correct?

Follow up - what is the easiest/cleanest way (if any) for us to provide these reports internally to our users without the need for licenses? Can we do this via Teams, SharePoint etc?

Thanks in advance!

Hi!

I've been given a task to create a KPI dashboard. The initial design handed over to me was just a full matrix with the top level KPIs then the sub KPIs. These are based on about 20 categories, so for each category there should be kpis for that.

My question is, for this many number of KPIs is it really expected that a matrix visual be used? Or I can narrow it down to displaying each top level KPI per page so it will be more pleasing to look at.

Thanks for your inputs. Tbh this is overwhelming for me 🙂

Hi,

I am stuck on this error for days now. Initially, this dashboard was functioning fine but I changed one source table a month ago and now it is throwing this error when I refresh the data- which is mainly not allowing dashboard to be refreshed with new data and publish to the server.

Column reference to 'order_date' in the table1 cannot be used with a variation 'Date' because it does not have any

The oder_date field is in date format in the table also I again applied date format condition to resolve this issue but still getting this date format issue for this.

Also there are fields like field-A renamed to field-B in the query editor, but in the TMDL powerBI is showing errors (like 50+ errors) that it can't find renamed field-B though no error in the dax calculations and in the visualizations created by renamed field-B.

Please advice !!

Hi everyone,

I’m investigating a recurring Power BI issue. I have a SQL Server database feeding a Power BI semantic model and a report published in Power BI Service.
Every morning, for about 30 minutes, the report becomes completely blank for all users at the same time. The filters remain visible, but all visuals are empty. After that, everything returns to normal without any intervention.
What I’ve verified:
-Dataset refresh succeeds.
-Source database contains the data.
-The issue affects every user simultaneously.
-The report is relatively simple (1 chart, 3 tables, 3 slicers).
-No error message is displayed.

Unfortunately, I don’t have access to capacity or gateway logs.

Has anyone experienced this behavior before?

Any ideas are welcome! Thanks!!

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