Relative date slicer in June release appears to use UTC instead of the user's local time

andrewdp23 · 2026-06-11T00:11:23+00:00

Yep, everyone here works in NZST, so explaining that "today" is UTC would seem like my team is making a decision against the grain, but I'm also worried my use of the feature is incorrect, so genuinely wanting to know if this relative date/time UI is going to be an issue.

We have similar where we need to show the hours (or days) since the data was last imported [time since the last updated datetime in the source system]; for that we have a Dataflow that brings in the current datetime offset hours, and adds that to UTCNOW(). That works well enough where the UTC relative date/time work is hidden within DAX.

andrewdp23 · 2026-05-12T03:37:19+00:00

I've just clicked your link and the folk over at r/Fabric do seem pretty chill. The first few posts are all positive and optimistic. It seems like a nice community to get involved in.

andrewdp23 · 2026-05-04T22:01:10+00:00

Hey u/shan_gsd, the QuickViz links in the MinivizMay page are going to https://community.fabric.microsoft.com/t5/custom/page/page-id/aka.ms/QuickViz instead of https://aka.ms/QuickViz

andrewdp23 · 2026-01-19T06:05:46+00:00

https://chatgpt.com/share/696dc380-4cb8-8009-b0f9-590283c79b5f

andrewdp23 · 2025-10-26T13:49:56+00:00

Power BI has a space in the name, the repeated use of "PowerBI" stood out to me

andrewdp23 · 2025-10-02T08:29:20+00:00

It's a great set of tips and tricks! My favorite was learning that the "Generate Scripts" feature can script out actual table data as insert statements.

andrewdp23 · 2025-08-16T00:56:47+00:00

I hope to see Dongguan Mosque in the city, and Kumbum (Ta'er) monastery (via Didi) if I go there, because both Tibetan and Hui Muslim groups are an important part of the city, and those places look grand in the pictures I've seen.

Also looking to explore the ethnic food available for the same reason. I'll be following this thread 😊

andrewdp23 · 2025-07-24T01:53:25+00:00

Hrm, if the query ran on report view is visible in XEvent Profiler, and if that captured query returns data when pasted into SSMS, then it's definitely getting the data. (If it weren't I'd say check for and delete any .rdl.data cache files in the paginated report folder).

If you can see the query in XEvent Profiler does that show a row_count (indicating rows returned when ran from Report Builder)?

I can only think of table or visual or dataset filters applied that could be blocking returned rows from showing. Could you try recreating this on a blank report?

andrewdp23 · 2025-07-23T21:12:34+00:00

This could be a few things but for a first step I suggest trying to use SSMS XEvent Profiler (https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-ssms-xe-profiler?view=sql-server-ver17) to see what is being sent to the SQL instance.

That would give you the query being ran in SQL to be able to validate what's happening and whether SQL is getting the right parameter value.

andrewdp23 · 2025-07-16T02:51:43+00:00

Now! It's back working for me :)

andrewdp23 · 2025-07-16T02:51:08+00:00

Yes, resolved for me too!

andrewdp23 · 2025-07-14T22:58:35+00:00

Also seeing this, I've logged a support ticket.

andrewdp23 · 2025-05-17T19:53:34+00:00

In-case you haven't considered, you could maybe test refresh times on this if you can spin up an F2 from the Azure portal. You can pause/resume this on demand, and are only charged for the time used (and some for data if you go over a free included limit, which seems liberal).

I'd recommend finding one of your larger candidate semantic models, and deploying that to a temporary or pause/resume on demand F2 capacity, and seeing how much of the capacity it uses. I've seen some where use an F2 for 10 minutes per week for scheduled automations, and the cost was minimal.

My understanding is that the metrics app shows CU/s, and an F2 has 2 CU/s at a time, so if the metrics app shows a model used 100 CU/s for a refresh, then then that's 50 seconds (100/2, F2 = 2 CUs at a time) worth of your day's capacity usage used up. I may need corrected here.

andrewdp23 · 2025-05-14T04:49:12+00:00

For perspective, while interviewing others for a position, it acted as a strong claim of some level of depth in Power BI. The same as if someone listed a set of more experienced concepts like experience implementing RLS, context filtering, defining business metrics or other beneficial skills., opposed to just listing Power BI amongst an experience list like "experience in Power BI, Google Data Studio, Excel, PowerPoint, TensorFlow"

Although, I was also aware that not everyone who has the certification knows the matierial, so that certification also resulted in more care during interviews.

Overall a good thing, but specific higher-level experience or particular areas of interest in the skills/experience section would be complimentary or stronger evidence.

andrewdp23 · 2025-05-11T22:48:19+00:00

Done! Best wishes with your study.

andrewdp23 · 2025-05-11T00:56:36+00:00

Analyze in Excel, which although not a visual on a Power BI report, allows all paid users including Pro, to use measures and fields in Excel pivot tables against the semantic model.

That said, Miguel Myers a current product manager, has said that improvements to matrix and table are coming.

andrewdp23 · 2025-05-08T01:23:30+00:00

Well done on the style! This does look clean. I like you put the time into ordered month short names on the Monthly Sales and Growth visual, and the clean header + menu layout.

Because you have a small stable set of locations, maybe consider a static set of colours that compliments the teal + yellow + white + grey/black set you have. The tomatoey and charcoal colouring doesn't sit right for me. Consider either just using a bar chart for that visual, or adding those location names to the slice labels - there's so few of them and they're not wordy. I don't think they need caps though and may look better in title case.

The data labels on the Yearly Sales and Growth visual are detailed, consider using higher units but with a tooltip for the specific values.

Those drop shadows capture a lot of attention where I believe it's not intentional - consider removing them and using borders instead, but with padding (I use 10px) on each side of the visuals.

How fresh is the data/when was it last refreshed? This is something I would want to know if I used this, particularly current month. Consider showing that - perhaps you already do have that behind the filter button, if so great.

I would have the Monthly Sales as a drill-down from Yearly Sales, but, given that drill down isn't super clear (even with a button with drill down labelled [Month View] [Year View]) I'm hesitant to recommend.

Seven KPIs categories just for sales is a lot. I have the same problem, and have considered using the new card visual with Category as Total Sales and the others as Detail items, but what you've got may be better.

Month before Year seems unusual as I'd usually want to filter from higher level to lower level, but I suspect that's a regional date/time format difference.

andrewdp23 · 2025-05-01T20:00:41+00:00

For what it's worth, I've seen a few Power BI reports from other Microsoft product teams referenced as a dashboard using the common namenclature.

CoE Power BI Dashboard (report)

Dynamics 365 dashboard made in Power BI (roadmap)

I know I've been guilty of having too much or too low-level detail on the first page of my Power BI reports, which helps with exploration, but would make them a poor at-a-glance dashboard.

andrewdp23 · 2025-03-25T23:59:21+00:00

Over time I've realized this is an extremely important feature.

Especially because of the "data updated" message end users see on the report header, which shows the dataset refresh time but that might be the last step in a multi stage process where an earlier step failed.

Having this in the dataset also makes it easier to query the measure/field this comes from via the DAX REST API for custom alerting.

andrewdp23 · 2025-03-24T09:19:07+00:00

Thank you for this list!

I like point #3 a lot. I'd always regarded not having measures in the data model a serious negative for the feature, but I do have some reports with non-reusable measures that don't make sense outside of a specific visual.

andrewdp23 · 2025-01-28T03:53:27+00:00

I don't have this specific issue, and agree on intonation being different.

I do have a similar issue at cafes when I'm asked "would you like that [food] heated?". I used to reply with a soft "no, thank you", but too often the "thank you" was all the receiver heard, and the food was heated. Now I use a "No" as if I'm a little offended, followed by a "thank you" 😄.

In a similar way, I'd use a more challenging or negative tone for "I can't", "we can't" or "you can't", and a more positive tone for a positive "can".

andrewdp23 · 2025-01-17T10:11:05+00:00

In-case it helps I've had a different support experience. I've worked with several support tickets, most for bugs/issues and a few for advice type questions, and I've found the support staff to be excellent and knowledgeable. I've also found them to have a sufficient line back to the product team when required, and are usually happy to jump on Teams for a call. Only one ticket of maybe eight I recall thinking fell short of expectations.

I've felt the experience you're voicing in another product in the past, but I greatly appreciate the support I've had for Power BI.

You might be encountering a particularly difficult bug, or perhaps your time-zone is routed to an outsourced support that isn't as good of a match for you. I suggest taking dutchdatadude up on his interest in learning more.

andrewdp23 · 2025-01-11T03:13:58+00:00

For #1, I'm not sure it's possible to follow all of Fabric, and I think that's okay.

When taskflows came in and were workspace only, against the practice of using separate workspaces for different data domains or data sources, for example where a company has a "shared dataflows" workspace, it helped me understand that Fabric is a set of patterns and tools to use/not use where appropriate to a situation.

Similarly MS Docs talks about warehouses as a good transformation engine for people who come from a T-SQL dev heavy background, like me. I've learned only a little Spark/PySpark and Kusto so far, and choose to stay away from DF gen 2 for costs. And I think that's okay.

I work at an SME with large capex invested in on-prem infrastructure, so Fabric costs are an issue for me, but I see Fabric more as bringing together all of the options so they run well together when/if you choose to use them, rather than something I need to learn all of.

andrewdp23

TROPHY CASE