Nicholas Jackson

Power BI Director at @TrinSoft. Previously BC consultant. Thoughts and opinions are my own.

[Nicholas Jackson @TS_NJackson]

@waldo1001 Co-pilot (or any other tool backed by a LLM) tooling for AL will always fall behind other languages. LLMs improve with more data, and there's nowhere near as much public AL code and writing as there is for other languages.

I use it for C#, but not AL for this exact reason.

[Nicholas Jackson @TS_NJackson]

@maxwiks A popular mechanic I watch on YouTube always gets complaints in the comments section saying "How can you point out XYZ and not fix it?!"

His response: "I fix what the customer pays for. I'd love to fix everything, but I run a business, not a charity."

[Nicholas Jackson @TS_NJackson]

@maxwiks After being a consultant for 3 years, I've finally learned the proper answer is "Help the client you can as much as the scope allows."

If they've engaged you to add a single visual to a report, and it's possible with the calculated column, then use it.

[Nicholas Jackson @TS_NJackson]

@JayPowerBI Is there a way to download previous versions of PBI Desktop? Oct 2023 release is causing a report to fail to refresh, and I've submitted a bug, but I need to get this report done for a client.

Any suggestions? Thanks!

[Nicholas Jackson @TS_NJackson]

@bertverbeek I'm hoping this happens sooner rather than later!

The out-of-the-box connection options (web services and API) are good enough for organizations with smaller datasets. But using those for anything over ~1M rows or ~1GB just isn't feasible.

[Nicholas Jackson @TS_NJackson]

@steveendow 1. Too many 3rd parties. More chefs in the kitchen will just slow the project down.
2. Moving targets/deadlines (i.e. a never-ending project).
3. Failure to include all parties (i.e. sales is running the project, never talks with manufacturing).

[Nicholas Jackson @TS_NJackson]

@bertverbeek @VillemHeinsalu Good post indeed!

@bertverbeek - how difficult was the conversion from ADLS to Fabric as the data destination?

[Nicholas Jackson @TS_NJackson]

#BCALHelp Is there a way to configure VS Code so that it automatically collapses empty brackets to a single line (i.e., go from lines 14-16 to line 11)?

[Nicholas Jackson @TS_NJackson]

@erpthoughts Running "npm build" will create a production-ready minified and bundled JS file under /build/js. This minified bundle has all of your JS, including your dependencies.

The only issue I run into is how it randomly names the minified file. Maybe a script could help?

[Nicholas Jackson @TS_NJackson]

@KeptyCZ Interesting, something to keep in mind!

This client has only ever been on hosted.

[Nicholas Jackson @TS_NJackson]

#BCALHelp Has anyone ever seen blank system fields on a record outside of the system ID? Would a configuration package do this?

[Nicholas Jackson @TS_NJackson]

@BenColeonBC Our clients would save so much money if they (A) used a new check stock that complied with BC's native layout, or (B) fully switched to ACH.

[Nicholas Jackson @TS_NJackson]

@KennieNP @demiliani Sounds good, thanks for the info.

Ultimately, a solution needs to be developed. We are starting to work with bigger and bigger clients, meaning more and more data. The current OData implementation is okay for small queries (i.e. master records), but struggle with ledgers.

[Nicholas Jackson @TS_NJackson]

@tonyabm_ We write almost all of our NACHA exports from "scratch" (we copy the base US NACHA export and go from there).

Having done a few of them, a 3rd party doesn't sound like a bad option...

[Nicholas Jackson @TS_NJackson]

@steveendow Great! The Azure App Registrations can be quite confusing, glad to hear you're keeping up with it!

As a warning: there are good implementations of OAuth and bad implementations of OAuth. If you see something that makes you scratch your head, don't be surprised!

[Nicholas Jackson @TS_NJackson]

@_DzMi What about adding telemetry events to the OnInsert/Modify/Delete triggers on the main tables? It could do a comparison between the rec and xRec to see what changed and log that via telemetry.

[Nicholas Jackson @TS_NJackson]

@_DzMi What concerns do you have about adding custom telemetry events? They would provide the most granularity and control over what's tracked. Plus, you can filter on the Azure-size which (and how many) events you track.

[Kilian S. @duichwer]

@TS_NJackson The other pattern you can find in the development of Microsoft is to use the ReadPermission check.
E.g.
https://t.co/ZWcJ0Rz6b8