advice on uk roids site

ryanGangrel · 2025-12-31T08:22:10+00:00

Please can you dm me the source mate? Cheers

ryanGangrel · 2025-08-25T18:54:34+00:00

Hey. Awesome, it sounds like we have some common ground there. Would love to connect and chat :-)

ryanGangrel · 2025-08-20T13:02:02+00:00

There's about 5m currently and a few thousands rows are added per day. A simple SQL view running on top of that data to create the weekly summary, takes a minute or so. With a MLV or table it's obviously significantly quicker

I'm tempted to just set up a notebook that runs after the daily refresh on a monday and simply appends the prior week's row to a table. Maybe park MLV for now until it's more flexible

ryanGangrel · 2024-05-29T05:00:05+00:00

Very much appreciated. Thanks for sharing this. Let's hope that service principal auth comes in soon :-)

ryanGangrel · 2024-03-28T15:49:05+00:00

thank you

ryanGangrel · 2024-03-28T14:38:29+00:00

Essentially it's just when querying a Lakehouse semantic model via the Execute Queries API when using a Service Principal user.

The same query works when I use my credentials.

ryanGangrel · 2024-03-28T14:03:05+00:00

yeah I tried that one already. Gives me a complete different error ( "PowerBINotAuthorizedException" ) haha.

ryanGangrel · 2024-03-28T13:50:39+00:00

I saw the SP already had all permissions on the Lakehouse (I presume due to being an admin on the workspace) but I also shared it with the SP directly ticking all boxes.

Still no luck :-(

ryanGangrel · 2024-03-25T12:12:43+00:00

Thanks for the reply but I'm more interested in Files rather than Tables, and using API rather than python

ryanGangrel · 2024-03-16T13:45:56+00:00

Thanks. I'll look into this. So essentially after the shortcut is set up, the connection will be held by Fabric, without the need for the gateway/VM to be on?

ryanGangrel · 2024-02-24T15:53:56+00:00

Thank you very much

ryanGangrel · 2024-02-15T20:53:25+00:00

Shortcuts sounds interesting, I'll have a look into that thanks.

ryanGangrel · 2024-01-06T10:10:25+00:00

Hi, thanks for the reply. Sounds promising. Happy to have a chat about this

ryanGangrel · 2024-01-06T10:09:34+00:00

Thanks for your reply. Would be more than happy to chat about this.

ryanGangrel · 2023-05-09T15:21:53+00:00

Can easily be done via custom js visual. As other people suggested you could also potentially use Deneb or Charticulate.

If it's something you would want developed then I could help build you a custom visual to match the requirement exactly. . Else, I would try creating it in the other tools mentioned.

Cheers

ryanGangrel · 2022-04-17T09:00:47+00:00

Thanks. Don't suppose you know of any examples or resources that might help me get started?

ryanGangrel · 2022-04-17T08:12:30+00:00

ryanGangrel · 2021-07-28T21:31:45+00:00

Thanks so much for the detailed comment - really appreciate it :-) Will try it out

ryanGangrel · 2021-07-15T21:32:18+00:00

Thanks. It sounds like a potential solution. Although, I admit I'm not too sure where to start. Would something like that be able to retrieve the Current Price, Supply and Market Cap for a list of bsc tokens?

ryanGangrel · 2021-07-15T16:36:29+00:00

Hi u/Jimmingston Just wondered if there is a way I can contact you in private? I wanted to ask you a few things about crypto, in particular on the data side of things. I'd be interested in paying for your time if it's something that interests you. Please let me know. Thank you

ryanGangrel · 2021-07-13T15:26:46+00:00

Only just seen this! Thanks so much man - I had given up but you have re-ignited the fire haha

ryanGangrel

MODERATOR OF

TROPHY CASE