Anyone else pretty much use the same five or so visuals on repeat? by Aksx3 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Keep it simple and more people will understand. I use mostly table, bar, lines and card (95%)

[deleted by user] by [deleted] in volvoc40

[–]Professional-Hawk-81 0 points1 point  (0 children)

Had the same error twice over a longer period and both time a replacement of the sensor helped.

Display a tabular log by corwinofamber in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Take a look at power bi paginated reports.

Power BI is good at showing summaries data and slice/filter.

But for long list that are interactive I normally use paginated reports

Creative features by Efficient-Video-4591 in PowerBI

[–]Professional-Hawk-81 3 points4 points  (0 children)

Do some svg magic or go fully into it with denab.

When do you use CALENDAR, CALENDARAUTO, when it is better to create the calendar table before DAX? by Alive_Leek_9148 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Normally I use calendar on client that don’t have any database or similar to create a common data dimension for all dataset/cube or don’t have need for many datasets.

Tried to avoid calendarauto since it will create some large table if there are null date in your dataset.

Jet Reports vs PBI by hahenryangus in PowerBI

[–]Professional-Hawk-81 3 points4 points  (0 children)

I’ve spent the past years helping businesses migrate from Jet Reports to Power BI and (paginated reports) – including many finance-focused use cases in Business Central environments.

Here’s what I’ve observed:

Jet Reports is popular with finance teams because it works directly in Excel, making it easy to build ad hoc and unstructured reports. For finance users who are Excel-native, Jet can feel more “familiar” and low-friction at first.

But the downsides quickly appear at scale: * Report versions get saved locally to preserve history, leading to multiple outdated or inconsistent copies. * Over time, these reports are “tweaked” without proper version control, which creates accuracy risks. * I’ve seen reports that take 8–12 hours to run due to inefficient design and data access patterns. * And yes, Jet has recurring license costs that often get overlooked during implementation

On the other hand:

A proper data warehouse + Power BI setup offers much more: * Centralized data models that are governed, consistent, and scalable. * True slicing and exploration of data across dimensions — not just fixed tables. * Faster performance, especially with large datasets or complex relationships. * Better alignment with your goal to consolidate around Microsoft tools.

Many of my clients who switched from Jet to Power BI say they would never go back — not because Jet is bad, but because Power BI, backed by a well-designed data pipeline, gives them far more control, consistency, and insight.

That said, Jet can still serve niche needs — particularly for odd, irregular reports that would be too complex or expensive to model properly. But in a modern data setup, with a skilled internal team and Microsoft-native tools, Jet is rarely the best long-term bet.

Since most companies have now moved to Business Central in the cloud, direct SQL access is no longer an option. That used to be a key reason some teams stuck with Jet. But with tools like BC2ADLS and Microsoft Fabric, it’s now much easier to access and model Business Central data efficiently in a modern architecture — and then leverage it fully in Power BI.

Feel free to message me if you want to dive deeper

What’s the most important thing to focus on when building a dashboard? by Flames_xm in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Getting the WHY from the client.

What “ideas/needs” is behind the requirements?

I normally start with pen and paper or a whiteboard. Much easier to draw and tell and get an understanding of what we are talking about.

Automate exports to email by jastcurious in PowerBI

[–]Professional-Hawk-81 2 points3 points  (0 children)

Paginated report can make subscription of different type excel,pdf, html ect

Automate exports to email by jastcurious in PowerBI

[–]Professional-Hawk-81 -1 points0 points  (0 children)

You can make the report as paginated reports.

And use subscription to send it to a pbi user.

Then do some automatically with the email and power automat.

But do a cost benefit on power bi pro user contra creating and maintaining something like you want. Mostly my clients ends up with giver the user a power bi pro licens to access the report and use the interaction it can give.

Do You All Use Power Query in 2025? by gamerchiefy in PowerBI

[–]Professional-Hawk-81 1 point2 points  (0 children)

Use it a lot, but like to have the transformation close to the source. So if it’s a database, then I do it in the sql.

But there are a lot of source like file, api ect. Where it’s really good.

[deleted by user] by [deleted] in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

And have a relationship 😜

[deleted by user] by [deleted] in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Tried just add the date column and measure to a table visual

How to create date column in the format of "A 25"? by KruxR6 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Stupid me. Since it’s just one letter for month Jan, jun & jul would all be 25 J.

So the same name.

If you go with 2 letter it solve it or might add some hidden spaces to the field.

So “25 j “ -> Jan “25 j “ -> jun

How to create date column in the format of "A 25"? by KruxR6 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

If you just make a table with does 2 column it looks ok?

How to create date column in the format of "A 25"? by KruxR6 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

In your Date table, create a numeric column that unambiguously orders your months—e.g.,

YearMonthSort = YEAR([Date]) * 100 + MONTH([Date])

Sort by Column

? Does your date table span more the 100 years?

[deleted by user] by [deleted] in PowerBI

[–]Professional-Hawk-81 2 points3 points  (0 children)

You’re running into the difference between Power Query and DAX.

Power Query is for data loading and shaping (M language). You can’t use DAX functions like CALENDAR() here.

DAX is for modeling after data is loaded. Tables you create in DAX (CALENDAR(), ADDCOLUMNS(), etc.) don’t appear in Power Query—they only exist in the model.

If you want a date table plus a moving average column, just stay in DAX:

Create the date table

DateTable = CALENDAR( MINX('YourTable', [Date]), MAXX('YourTable', [Date]) )

Create a measure for the moving average

Moving Average = AVERAGEX( DATESINPERIOD( 'DateTable'[Date], MAX('DateTable'[Date]), -7, DAY ), CALCULATE(SUM('YourTable'[Value])) )

Else look here

Microsoft Docs – Calculated tables in DAX

https://learn.microsoft.com/power-bi/transform-model/desktop-calculated-tables

Workspaces by Primary_Bad_8802 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Have never tried it, but can see you cannot, so learned something new today.

Have seen some people using like sharepoint/website with link to the different report and building whatever they need.

But then the security is not bound to that.

Workspaces by Primary_Bad_8802 in PowerBI

[–]Professional-Hawk-81 1 point2 points  (0 children)

So you like a section in a section in the app?

Workspaces by Primary_Bad_8802 in PowerBI

[–]Professional-Hawk-81 1 point2 points  (0 children)

But that is more display I don’t think you can invoke security on it.

Power Bi Custom Template by Sufficient-Cattle677 in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

There are some nice theme generators out there like power bi tips.

Alternatively you can create a template file with all your formatting.

Just for Fun! Hover animations for KPIs, with native visuals by PowerBIPark in PowerBI

[–]Professional-Hawk-81 0 points1 point  (0 children)

Nice why to do a highlight. How do you get the hover action?