matnav.co.uk
#MSDyn365BC consultant. Reporting specialist
#PowerBI
#JetReports
#SQL
#Cosmos
Professional profile of @matthewperren.bsky.social
1,059 posts
338 followers
195 following
Regular Contributor
Active Commenter
comment in response to
post
Can’t talk about lockdown. I worked throughout.
comment in response to
post
It’s an entirely rational dislike
comment in response to
post
Much better
comment in response to
post
I used to keep a reading diary when I was a bookseller. I never got higher than 49 in a year. 🙂
comment in response to
post
Marks & Spando
comment in response to
post
Wait! Yes you CAN!
You can’t post depreciation other than by a manual journal. But you can depreciate negatively to increase the negative NBV back to zero.
comment in response to
post
Interestingly it’ll allow me to enter the path into a parameter and will take the contents of the parameter as a data source. But only if it’s entered directly into the parameter by the user. Not if the parameter is populated from a list query.
comment in response to
post
That’s exactly it.
I’ve got a wee button in excel that lets the user browse for the file. The cell it returns to is a named range “Path”
That is then stored in PQ in a single value list called Path but Csv.Document(File.Contents(Path)) returns this error
comment in response to
post
Plus it absolutely refused to recognise the date of delivery I wanted. Given that you can’t make customers email you in a specific format it’s next to useless.
comment in response to
post
Nah, MS don’t want you using AI services for free so they cut you off after about 6 emails.
comment in response to
post
The means by which Power BI connects to BC is hopeless.
I just want a connector that allows me to pick what tables and fields I need. Not just pages.
Jet and Cosmos both have such a thing but not MS’s native reporting tool. 🙄
comment in response to
post
Don’t.
comment in response to
post
At one and the same time that I’m gently telling them that the thing ChatGPT tells them they can do, they actually can’t. Or that the process it’s come up with is wrong.
comment in response to
post
“But that just doesn’t work!”
“Can’t that be done quicker by a person?”
“Why have they bothered? Does anyone actually want that?”
comment in response to
post
I do hear what customers say. I’m repeatedly asked to demo the BC AI features and the sense of bewilderment from them when I do is nothing short of excruciatingly embarrassing.
comment in response to
post
Apparently it’s more complicated than it seems!
comment in response to
post
Thank you! It’s being done by one of our devs.
comment in response to
post
Isn’t that what the Scottish Parliamentary election system is designed to deliver though?
comment in response to
post
Mine just means “Peterson” in French
[weeps]
comment in response to
post
No one at that level “goes straight to jail” in the USA. Look at your president. He’s been a crook for decades. Has he ever even sniffed the inside of a jail?
Musk will be free as a bird until his dying day.
comment in response to
post
Whom
comment in response to
post
Fundamentally all social media is boring. Being invited to give a toss about some rando’s (me included) hot take is less and less my idea of a good time.
comment in response to
post
In the midst of another one. I plunge into the data, come out with a dozen questions which throw them into a tail spin because they realise that everything is NOT FINE!
Bless them❤️
comment in response to
post
This is excellent Luise!
When I’m migrating customers from legacy systems into #MSDyn365BC it’s incredibly common to be assured that the quality of the data is high, only to discover that it’s so poor as to be virtually broken. The pride people take in their workarounds is sweet but depressing.
comment in response to
post
That’s very odd!
comment in response to
post
😂😂😂
comment in response to
post
I can move down rows and the filter stays. (GB localisation)
comment in response to
post
Don’t tell me….and when they came to repeat it no one could remember how they’d done it in the first place?
comment in response to
post
Ah! Good times!
comment in response to
post
I bet it can’t do anything with the tools illustrated
comment in response to
post
I was recently goaded into engaging with some clown who asserted that for all data analysis SQL should be the first tool you use and if you didn’t know SQL to a very high level you should get another job
I suggested that your choice of tool might be context specific and was showered with abuse
comment in response to
post
Ugh. I’m a #MSDyn365BC consultant. For my Power BI work I have to *actively* disconnect PBI from its last BC data source - a multi-click epic.
comment in response to
post
LinkedIn is horrible. It’s 99% engagement farming. The algorithm continually seems to shove people who feel it necessary to put their MBA after their name.
A couple of #MSDyn365BC folk I really value are exclusively on there. If not for that I simply wouldn’t bother.
comment in response to
post
I’ve done a great deal of public speaking in my time and I’m quietly that I’ve never given or even felt the urge to give a nazi salute whilst doing so.
comment in response to
post
I’ve *literally* just found that by googling “<day,2>/<month,2>/<year4>”!
I’m guessing I must have read it before at some point or how would I have known to try that format?
Anyway…thank you as always Natalie!
comment in response to
post
Haha!!!
Sorted out the dates too!
<day,2>/<month,2>/<year4>
Inexplicably there’s no comma between “year” and “4”
Approximately 1 million miles away from being intuitive.
comment in response to
post
OK. I’ve sorted out the spaces. But the dates?
It’ll do me 20/05/25 if I use “en-GB” or 20050025 if is use <day,2><month,2><year,4>. And I can rather uselessly get “dd/MM/yyyy” if I put that in the format column
The bank wants a 4 digit year. So how to do it?
comment in response to
post
The latter part stands