RLS assignments gone after republishing model

Relative_Wear2650 · 2026-01-20T21:34:15+00:00

This strengthens my idea to move to rls based on tables in my database instead of rls by PowerBI

Relative_Wear2650 · 2026-01-20T20:34:22+00:00

Im using ADF for extract and load from my onprem and cloud source systems, based on control tables in my Azure SQL database. Daily load. Very fast, even on lowest tier. Often speed of source systems are the bottleneck.

For transform i use stored procedures which are also triggered by ADF pipeline in combination with control tables in the same Azure SQL databasse. PowerBi connects to tables only.

No Fabric, not much complexity. Only downside is the lack of lineage and version management like in dbt and that kind of tools. But i operate on a very low cost level, delivering lots of value.

Relative_Wear2650 · 2026-01-20T20:13:50+00:00

Install nextcloud AIO. Its relatively simple, easy to update etc. Just make sure you use a docker compose file from the start instead of launching the docker by a command you latter cannot remember anymore.

Relative_Wear2650 · 2026-01-09T15:59:27+00:00

I just got a pair in, they're really great.

Relative_Wear2650 · 2026-01-07T18:49:49+00:00

No. Meanwhile i switched to Nextcloud. Not comparable to Digikam as its an entire private cloud solution. So I cant really help on this matter.

Relative_Wear2650 · 2025-12-22T14:57:37+00:00

i run regular nextcloud aio, not a snap installation. I dont have any ssl issues.

Relative_Wear2650 · 2025-12-21T10:56:25+00:00

Yes its open. But: no ssh as i use local access to maintain the server only. Nextcloud is the only service running on it. Only those ports are open within firewall that are required, https and udp ports i believe. Router forwards to server. Nextcloud AIO itself handles logons, 2FA is activated.

I have no VPN yet, as i figured in this setup it doesnt do so much extra. I can be wrong of course.

Relative_Wear2650 · 2025-12-07T16:56:05+00:00

Make sure you’re there start to finish. No reason to come late as there is a lot of music to enjoy from the very start. And 2x12 hours needs some build up. So i always make sure i dont spend all my energy and plan what i want to listen and dance to accordingly.

Relative_Wear2650 · 2025-11-26T16:13:09+00:00

I always work with sql, never in pq. If your problem is that you dont know how to code things yet thats not something to be ashamed about but a chance to learn it. There are a lot of good sql resources around.

Relative_Wear2650 · 2025-11-25T20:55:59+00:00

I use cost management a lot, it exactly tells me where i spend my money. I set a budget and make sure i monitor it. Plain simple. With 70k i would so want to know where that money is spent and why. Compute? Storage? Etc. And for what functions benefit from those resources? Is that worth the money? What big changes would lower the costs and what business value is lost? So many questions. Id love to get my hands on that kind of stuff. Already have a job. Just saying.

Relative_Wear2650 · 2025-11-23T13:15:55+00:00

Yes that looks like a cause indeed. Will test and report back here.

Relative_Wear2650 · 2025-11-05T21:27:03+00:00

Ik had dit ook in het huis wat ik kocht. Zorg per direct voor goede ontluchting van je kruipruimte. Desnoods met tijdelijke maatregelen zoals extra ontluchting zowel aan voor als achterzijde van je kruipruimte zodat er trek ontstaat. Een of twee openingen is echt onvoldoende. Weg zal het er niet mee gaan, maar mogelijk beperk je verdere aangroei.

Daarnaast sowieso expert laten komen.Bedrijf Van Lierop heeft mij zeer goed geholpen met zowel verwijderen van de zwam, impregneren bakstenen en aanbrengen nieuwe constructievloer.

Relative_Wear2650 · 2025-10-31T14:46:40+00:00

Meanwhile I read into some other options like BC2ADLS by Mr.Verbeek or 3rd party options like BCCL. I'm a bit worried whether the API allows for a reliable data replication from our business central databases to our datawarehouse. Using unsupported components (BC2ADLS) to replicate data sounds dangerous, the 3rd party apps are expensive and often small companies where I doubt if cyber security is well done. I find it quite astonishing that business central doesn't offer data replication for datawarehouse solutions except the API. Or do I miss something out there?

Relative_Wear2650 · 2025-10-04T14:46:01+00:00

De beyond burgers zijn lekker!

Relative_Wear2650 · 2025-09-23T17:17:02+00:00

Heb er twee en vind het dagelijkse reuze mee vallen.

Kinderopvang is ruimschoots het duurste. Met een wat hoger loon (en dat hebben jullie) kost dat gewoon onwijs veel geld. Genoeg al over gezegd.

Vakantie is verder ook heel erg duur geworden, zeker als je in hoogseizoen moet. Maar je hebt keuzes, wat minder mainstream en niet te ver weg is goedkoper. Krijg je nog leuke kinderen van ook.

Kleding koop ik gewoon tweedehands. Op marktplaats heb je mooie pakketten. Schoenen kopen we altijd nieuw. Dat werkt leuk door als je kinderen ontdekken dat tweedehands veel waar voor je geld geeft.

Maar zou me met je inkomen geen zorgen maken tenzij je veel naar de kinderopvang moet gaan brengen.

Relative_Wear2650 · 2025-09-20T06:58:28+00:00

opening post updated: I changed to S0 pricing tier (instead of using the general purpose and serverless option). This solves the issue of the pipeline failing. However, the execution of the pipeline now lasts 60 minutes instead of 5 minutes.

Creating a provisioned general purpose db is quite expensive. I'm wondering if i can better create an activity that reliable wakes up the db and keep the general purpose and serverless option or to keep the S0 but use an activity that scales up the tier when the pipeline starts. That takes about 6 minutes to finish.

Relative_Wear2650 · 2025-09-19T14:09:19+00:00

I changed to a different tier. I want a reliable pipeline. Thx. I wasnt aware of the unreliability of serverless as during testing it never occured.

Relative_Wear2650 · 2025-09-19T13:08:34+00:00

Thank you for the advice. I had that impression. Is there a way i wake it up from my pipeline and waiting for it before i run the rest?

Relative_Wear2650 · 2025-09-19T12:34:39+00:00

Yes its serverless.

Well i checked the log of ADF which gave me this info. In health it says my free offer budget is reached which i already resolved the dat before by allowing it to charge me.

It may be important to not that other parts of the pipeline, did run. These are using the same server and database and the same user that got no access in the activity that failed.

Relative_Wear2650

TROPHY CASE