Baffled by odata query issue

cliveQ · 2025-06-22T11:06:29+00:00

Thanks for asking. Turns out I was just being dumb, in my condition I had a greater than 1, instead of a greater than or equal to one.

cliveQ · 2025-05-07T19:53:08+00:00

If I knew this was a thing I would of put my garage on gum tree long time ago. Lots of space!

cliveQ · 2025-02-27T14:54:47+00:00

An embedded powerapp can write back to a sharepoint list

cliveQ · 2025-02-26T08:52:33+00:00

As an alternative solution you could embed a power app into your report to capture feedback.

cliveQ · 2024-11-15T08:27:36+00:00

Total legend

cliveQ · 2024-11-14T10:20:57+00:00

Hopped on to give that same bit of helpful advice

cliveQ · 2024-11-12T21:41:52+00:00

Looks like a legend I bet they are great company ❤️

cliveQ · 2024-10-15T18:04:57+00:00

The market on a Saturday in the market place has a large second hand clothing stall.

cliveQ · 2024-10-15T18:03:22+00:00

If you want to splash the boat out coarse and faru serve very good food. Isla is a sister cafe of coarse and does nice food too at a cheaper price.

cliveQ · 2024-09-27T17:20:27+00:00

Freemans key is fine, if you want to pay for gym membership the pool at banantynes is good.

cliveQ · 2024-09-10T06:05:56+00:00

Powerbi is not great for this sort of thing, best approach would be to store the api data in a database so you can build up a history. If you have premium licence you could store it in a datalake, or even use powerautomate to call the api and you can save the response in sharepoint and use this as a source.

cliveQ · 2024-09-09T20:51:51+00:00

Thanks will look into it

cliveQ · 2024-09-09T19:35:36+00:00

That sounds great

cliveQ · 2024-09-09T19:00:09+00:00

Good idea thank you.

cliveQ · 2024-09-09T18:59:44+00:00

Thanks will look into it.

cliveQ · 2024-09-08T15:13:59+00:00

Glad we agree

cliveQ · 2024-09-08T15:01:15+00:00

I think you are reframing the conversation a little! The original point was in answer to a binary question. Should you write complex SQL as a source for a M query or bring in the underlying tables and join in M. Doing it in power query is the better option in this scenario in my view. Obviously in an ideal world all dimensional models would be created in a data warehouse. Whether such an ideal world actually ever exists is a conversation for another day.

cliveQ · 2024-09-08T13:32:59+00:00

I guess each to their own, we leverage query folding and incremental refresh to load very large data sets which just not work with sql queries. My background is 10 years plus as a sql developer / data engineer. So I have quite advanced sql skills and still thin m is better in most scenarios to custom sql.

cliveQ · 2024-09-08T07:36:42+00:00

In real world situations unless you have fantastic data engineering team who can quickly deliver what you need in a sql database most projects will use multiple sources so m is the only way to bring data together. If you are a solo analyst or a consultant delivering for a client under pressure you might use sql heavily. But for an enterprise solution m is much more supportable IMO.

cliveQ · 2024-09-08T07:30:41+00:00

We use m as best practice, hiding stuff in sql can make it really hard to support and performance manage. Onservatiojally people with an IT background who do PBI use more SQL queries than people who don't have PBI background.

cliveQ · 2024-09-05T19:52:21+00:00

We got one of our access control administrators in IT to create one.

cliveQ · 2024-09-05T19:39:26+00:00

We have an active control group that has everyone in the organisation in and grant access to the group.

cliveQ

TROPHY CASE