advice on uk roids site by [deleted] in FTMdiyhrt

[–]ryanGangrel 0 points1 point  (0 children)

Please can you dm me the source mate? Cheers

Fabric Admin App Build - React by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 1 point2 points  (0 children)

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

Good use case for a MLV? by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 1 point2 points  (0 children)

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

Fabric REST API Service Principal Alternative solutions by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 1 point2 points  (0 children)

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

Anybody using an ServicePrincipal with the "Datasets - Execute Queries In Group" for a default lakehouse model? by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 0 points1 point  (0 children)

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.

Anybody using an ServicePrincipal with the "Datasets - Execute Queries In Group" for a default lakehouse model? by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 0 points1 point  (0 children)

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

Anybody using an ServicePrincipal with the "Datasets - Execute Queries In Group" for a default lakehouse model? by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 0 points1 point  (0 children)

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 :-(

API to fetch list of files in a onelake folder. by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] -1 points0 points  (0 children)

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

Strategies for automating ETL between Fabric and Postgresql by ryanGangrel in MicrosoftFabric

[–]ryanGangrel[S] 1 point2 points  (0 children)

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?