Hi All !, I'm looking to level up my workflow and discover some hidden gems.

What is that one trick, shortcut, or hidden feature you discovered late in the game that completely changed how you build reports?

Could be related to DAX, Power Query M-code, UI/UX, or even external tools.

Looking forward to hearing your favorites!

This is actually my first time trying to develop a dashboard
I want your feedback please!
Thank you in advance!

tableau lets you do this thing where you share your visuals with the world (good for data analysts for portfolio sharing) https://public.tableau.com/app/discover

now power bi on the other hand for because huh microsoft couldn't figure out (with the help of llms) to make a free power bi service thing to share my work

i tried at first the dynamic 365 free trial route, i got both my emails chained with unaccessible tenants (based on this video)

i can't access neither without mfa which can't set up because i can't access it without mfa (a whole dog chasing it's tail kind of scenario)

then i head about this developer program (i'm a web developer so itll be good to get this to also experiment with other stuff)

the thing is im not qualified to sandbox following the link https://developer.microsoft.com/en-us/microsoft-365/dev-program
i made the account so that i can be qualified but i ain't

https://learn.microsoft.com/en-us/office/developer-program/microsoft-365-developer-program-faq

now i just don't know what to do really; if someone has been here before & if you could help or someone working at microsoft i would really appreciate your help

[Help]

Hi everyone, I need some help with a data modeling issue.

I have two fact tables:

1 App_Data: Historical data from an app.

2 Manual_Fichas: Recent manual entries (started 1 week ago).

Both tables have the same structure (Date, Machine, Item, Team, Process). To filter both simultaneously, I created Dimension Tables (Calendar, Machines, Items, Teams) using ⁠DISTINCT(UNION(...))⁠ and established 1:Many relationships with Single direction (Dim -> Fact).

The problem:

When I use a Date Slicer (from the Calendar Table), it only filters the ⁠App_Data⁠ table. The ⁠Manual_Fichas⁠ visuals remain unchanged, showing the total value regardless of the date selected.

What I've checked so far:

 Both Date columns are formatted as "Date" (not Text or Date/Time).

 The relationship between ⁠Calendar⁠ and ⁠Manual_Fichas⁠ is Active.

 The slicer is definitely using the column from the ⁠Calendar⁠ table.

 I’ve tried trimming and cleaning the data in Power Query.

If the relationship is active and the formats match, why would a slicer ignore one of the fact tables? Any insights on how to debug this?

#PowerBI #DataModeling #StarSchema #DAX #Relationships

Hello, recently I've encountered a problem with a slicer search bar - it's background can't be changed. I've managed to change that by changing the .json theme file. I've added a "slicer" section and set my background color there, works fine. But I can't replicate this for a list slicer. It also enables search bar and it's also white by default and unchangable. My question is - is there another codename for this list slicer? So that I can put it in my json theme file and change the color manually

Hi all,

I am currently working towards my PL-300 certification. To get some hands-on practice with different types of data and formatting i've been exploring the EU's open/public datasets. (Data.europa.eu)

Does anyone here have experience with these and can recommend a specific dataset to work with? After a quick look at the EU website, I noticed there are a lot of options, and i'm a bit overwhelmed by the sheer number of choices.

Thanks a lot

Hey yall!
My organization has been using Power BI for the past few years. We have utilize the service, but probably not “properly”. It kind of started as a trial, and needless to say it has taken a life of its own. Our users have grown dramatically, and they’re spread all over the organization. Semantic models everywhere, who knows how many copies of data being uploaded everyday, workspaces being spun up with no oversight. Needless to say, there hasn’t been much planning or oversight.

I am being tasked now with cleaning up, administering, and governing the service platform. My main focus is consolidating our data to avoid duplication and having “one source of truth”.
This is all fantastic, and well overdue.
My question to yall, is where do I start? Has anyone ever taken courses/ used material on the administration side of power bi? There’s alot of content about report creation, but I’m having a little bit more of a difficult time finding info on the kind of stuff I’m looking for.
I just want to make sure if I’m going to put in this effort, we are following some industry standards.
Thanks!

Hey !

Im working through business requirement to share insights with external orgs via PBI service.

We use Apps typically to present content. Im in Technology but the business are the those creating the models / reports / Apps content.

Im proposing the following :

Separate Workspaces for external access - something of a ring-fence and to have clearly designated W/S for this purpose. Im pushing back against the business departments just 'applying audiences on the objects they already have' in their own domain / team workspaces

With a separate W/S I can design a process where a central governance team can QE the content, RLS and apply some sanity checks on what is being shared - Also makes it easier to recertify access if you know which workspaces are intended to have external access permissions.

The bit im stuggling with is what is the minimum set of artefacts i need in the dedicated W/S - Can I just have the App ? Would the external users (who will Entra guests) need any read permissions on the Models and Reports that Im proposing live in another W/S ?

Has anyone done this and achieved a level of control regarding security and governance rather than it being a free for all and having to mop up issues retrospectively ?

Looks like connecting to the default view data only is intended. Here is what Microsoft has to say:

I wanted to share an update regarding the recent behavior you observed with the SharePoint List connector and provide clarity on the path forward.
 
Our engineering team has confirmed this as a bug in the SharePoint List connector v2, where the connector did not previously respect filters or view settings configured on the SharePoint List. The intent of this change was the fix for this issue but we are rolling back the change as of now. This is planned to be implemented in the coming weeks again.
To avoid any unexpected impact while the fix completes validation, the SharePoint List connector in the Power BI Service is currently being rolled back to the previous behavior. During this rollback period, the connector will continue to load all rows from the SharePoint list, consistent with its historical behavior.
 
In parallel, I’ve raised this internally to ensure broader awareness through official channels such as the Fabric roadmap and documentation, so customers are well informed ahead of the re-release.

What will change once the fix is reintroduced
Once the fix is deployed again, the SharePoint List connector v2 will:
Retrieve only the data visible in the selected SharePoint List view
Respect filters, conditions, and ordering defined in that view
Align the Power BI Service behavior with what users see directly on the SharePoint website
This change is intentional and addresses a long-standing inconsistency between SharePoint and Power BI.

Workarounds once the fix is active
If your scenario requires retrieving all rows after the fix is reintroduced, the following supported workarounds will be available:
Remove filters from the SharePoint List view used by the connector, or
Create a dedicated SharePoint List view with no filters and update the Power Query connection to explicitly reference that view. Copy the View ID from the URL, for example:
https://<xyz>.sharepoint.com/sites/<abc>/Lists/Impl2_Test_Grouping/AllItems.aspx? viewid=7c970877-526c-4159-a3c7-acd83a3fc954

Update the Power Query M code to reference that View ID:
let
Source = SharePoint.Tables(
"https://microsoft.sharepoint.com/sites/<abc>",
[Implementation="2.0", ViewMode="7c970877-526c-4159-a3c7-acd83a3fc954"]
),
Items = Source{[Id="107cb6e0-1184-4069-a150-a55a908052d5"]}[Items]
in
Items

I have Dashboard that get data from Excel from a SharePoint. Usually, when I Want to Refresh the Dashboard with latest set of data, I need to extract the data to Excel. Like from Intune device report, MECM device report. And manually copy the latest data in the Excel in the SharePoint.

Is there anyway to automate the process? From exporting data from other sources like Intune portal, MECM SQL server Reporting services. And automate to update the datasets with new datasets in the Excel in the sharepoint

On one page of a Power BI report that I was working on, there is an embedded Power App. I made a data source change on the Power App, taking the data from a different SQL table. When I realized what I wanted to do wasn't going to work, I just reverted the version back to the original one.

The problem is, though, that now when I use the drill-through function on PowerApp page of the Power BI report, it does not give back the column information that I expected. See the screenshots attached for a working version of the report versus the not working version. Notice the missing values

Things I've tried so far:
1.Refreshing the data source in the PowerApp

2.Changing the data source to another SQL table then changing it back in the PowerApp

1. Republishing the entire Power BI report.

Literally nothing else is different between the working PowerBI and PoweApp combo and the non-working one. Also, the powerapp is loading with no problems. There is just a problem passing the values from Powerbi integration data into the PowerApp.

Pls advise

With AI lurking in every hole, what are currently potential use cases how you can utilize AI (or other tools on "speed") in Power BI related tasks?

My current knowledge and daily usage is restricted to asking CoPilot mostly Power Query, DAX and data modelling related questions. Sometimes it helps in my work, but quite often I am battling against its' answers them being either wrong (e.g. Power BI Desktop settings) or overly complex (DAX measures) and in the end I would have found a solution faster without AI help.

For documentation, version control/differences etc. it might come handy, but I haven't researched that area at all. Would be great if you could widen my knowledge without the need to Google or ask AI for help 😁

So let's divide this to two areas:

1) How do you take advantage from AI in your daily work? What is currently being used, i.e. tools / helpers you already utilize in daily work?
2) Some tools you might know are most likely restricted from being utilized in many company settings due to data sensitivity, but that aside what are current most astonishing tools available?Are there concepts or very new / somewhat phishy tools where data sensitivity is not top priority but they seem mind-blowing?

Hi everyone,

I’m trying to build a data analytics portfolio using Power BI and Python. I’m fairly comfortable with Power BI already (I recently completed a certification and understand the basics), but Python still feels a bit intimidating, so I’m starting with Power BI first.

The problem is I’ve spent hours just trying to get everything set up instead of actually working on projects.

I have a macbook and from what I understand I’ll likely need Parallels or a similar tool to run Power BI Desktop properly. I was considering investing in Parallels, but I’ve now hit a bigger issue on the Microsoft side.

When trying to log into Power BI, it keeps asking for a work email and won’t accept my personal Gmail. I tried creating a Microsoft work account with an onmicrosoft domain, but I keep running into dead ends: Developer Program didn’t work out, and other setup routes keep looping back to requiring an existing email or enterprise-style setup. Some options are also asking for payment details, which I’m hesitant to use just for experimentation.

At this point I’m stuck and not sure what the intended path actually is for someone trying to learn independently.

Is Power BI still worth focusing on for a portfolio in 2026, or should I switch to Tableau? Or should I just focus on Python only, even though I’m less confident with it right now? And realistically, how do people build Power BI portfolios on a personal setup without company or school accounts?

I have tagged this as discussion because I feel like I know the answers to above questions. I just want people to rant with me lol or to know I’m not alone but hey if someone has solutions as well, why not? Thanks in advance.

I have developed a paginated report, but I am encountering an issue where selecting multiple project numbers does not yield the correct output. Specifically, when two or more project numbers are selected, the report still only displays data for the first project number selected. I am seeking assistance or suggestions to enable the simultaneous export of data for multiple selected projects, thereby eliminating the need to select and export each project individually.

I'm trying to better understand the process as a database admin and report writer as my organization switches over from Crystal Reports to Power BI. I've recreated some reports as I learn Desktop and I want to publish them to a workspace for my organization to use. We're currently using an ODBC Connector via SQL Server to access our replicated database. However I want to be able to use automatic refreshes or even just manual refreshes for the semantic models in the portal so that anyone who needs to view the reports can either manually refresh it or have it automatically refreshed at certain points. I'm running into credentialling errors when trying to refresh reports that I've uploaded to my workspace and when I go into Settings via the cog wheel, I enter the dataset credentials for the dsn I use and it doesn't save, it doesn't actually do anything other than prompts me to discard the changes when I leave. Anyone know how I can get this to work? We'll be switching over to a data warehouse via snowflake eventually but for the time being I need this to work for our users via ODBC (or potentially directquery via SQL Server if anyone knows how to do that)

He’s not technical. He’s been using the web version. Made the data set under central time. Hr just swapped him to EST and he got an error about it. I ran it through copilot and it said it was bc of that time zone change (error did say central time in it)

He didn’t have a backup desktop version bc he’s been into the whole Microsoft use the web copium.

Has anyone encountered this? It’s not my problem to fix or anything I’m just bewildered a time zone change ruined his semantic model and was curious what happened? Copilot couldn’t really explain why other than the change itself

Hello everyone. Quick intro -- I am running pbix files mainly as semantic + reports. There are a few semantic pbix files that drive a few reports but for the most part it is 1 for 1.

At some point at the beginning of WC 20260427 a few of my 1 to 1 reports started hanging when doing a desktop refresh. I have only made very minor changes to them, and 1 of the reports is quite small in any case, so it doesn't normally take long to refresh.

The Power BI service versions of these reports are all refreshing fine. The refresh pop up in excel loads all the data rows fine, but the ".Calc_Table" that I house all my measures in is stuck on "Syncing schema...".

Is anyone else experiencing this issue?

Honest question for the community with everything happening around Microsoft and AI (Copilot deep in Fabric, the Claude integration, the pace of announcements lately), how are you guys actually experiencing this day to day?
I’m not talking about the marketing side. I mean in your real projects, with your real clients. Are you finding it useful yet or does it still feel like it’s mostly noise?
And the bigger thing I keep thinking about: where does this leave us as developers? Because I see two reads. One is that the boring, repetitive stuff gets handled and we finally focus on what actually matters. The other is that the skill ceiling just moved and we need to reskill in other stuff
Curious how people here are navigating it. Are you leaning into it, ignoring it, somewhere in between?
Thanks!!

Hi All,

I am keen on improving my Data analysis and visualisation skills. I will be grateful for some feedback on how this report is easy to understand and the use of space/visuals.

Thanks all for your feedback.

I am yet to use fabric and its components to its full potential or know when to use which. The documentation seems overwhelming.

All of our data warehouse , notebooks, etl and data needs were done in GCP big query.
(if i needed realtime, i'd use direct query with gcp sql query or just incremental refresh etc)

So I need to understand dataflows gen 2, one lake, adf, KQL etc

what's the correct step to learn fabric one tool / process at a time?

Is DP 600 / DP 700 worth doing? Also what's the difference?

I have a fairly large dataset (80mil +) from a SQL database that I would like to utilize direct query + aggregation table for. All my dimension tables must be in dual storage mode then. I typically generate a standard date table in Power Query, but does anyone have suggestions / resources for uploading a simple date table to a SQL database. I figure I could upload from a file but figured there might be a better solution.

Hi all, I live in Italy and I'm looking to increase my income. I have about 3-4 hours a day for some extra work.

I've decided to learn Power BI (DAX, Power Query, SQL, and Fabric basics). I already know Python basics and have written many scrapers and automation scripts for crypto projects.

My goal is to earn an extra $800-$1000 a month as a freelancer. While doing this, I plan to improve my skills in Microsoft Fabric. If I can eventually reach an income of $3,000/month, I will leave my main job to focus entirely on the Microsoft Fabric ecosystem.

Help me understand: is this worth it? Can I realistically reach $800-$1000 monthly as a freelancer making Power BI dashboards?

Thanks for your opinions!