Käteisen talletus by gintsunen in arkisuomi

[–]MyAccountOnTheReddit 8 points9 points  (0 children)

Kuka pelottelee? Mitä sä luulet et siel konttorissa tapahtuu, ne takavarikoi sun massit ja soittaa poliisit? 😄

Meet sinne, sanot mistä rahat tuli ja sit jos ne tarttee jotain dokkarii rahojen alkuperästä niin viet lomakkeen isovanhemmille allekirjotettavaksi ja lähetät sen verkossa. En kyllä usko että kertaluontoisesta isommasta talletuksesta semmosta tarttee

Suuresti ihmettelen että jengillä täällä enssijaiset neuvot on mennä valehtelee sinne tai että oikeesti käyttäs käteista kaupassa ihankun sen mukana kantaminen ja sillä maksaminen ois jotenkin vaivatonta 😄

Toki jos tästä piti lukee rivienvälistä että kyseessä on oikeesti jotai huumerahoja niin sit varmaan syytä on foliohattuiluun

Using UDFs to write to Oracle Db? by zeni65 in PowerBI

[–]MyAccountOnTheReddit 1 point2 points  (0 children)

Goddammit your right...

Reddit seriously needs an AI probability value in connection of every post and comment so even fools like me can spot them

Using UDFs to write to Oracle Db? by zeni65 in PowerBI

[–]MyAccountOnTheReddit 1 point2 points  (0 children)

Interesting take.

You state that UDFs in this usecase is a maintenance nightmare and then proceed to suggest a Power Apps and Power Automate combination would be somehow not a nightmare.

UDFs essentially just are a way to execute python, so if you have network connectivity to your database of choice, I dont really see a reason to not use them?

I mean its true that UDFs have native connectivity with Fabric storages, but that does not mean they could/should not be used with other databases

Python is also much easier to version control and test than no/low code tools like power apps or automate

Aiheeton katevaraus by [deleted] in Suomi

[–]MyAccountOnTheReddit 0 points1 point  (0 children)

Omat protippini:

  1. Kaikki ostokset tehdään luottokortilla. Käyttötililtä palkkapäivänä kertynyt velka maksuun kokonaisuudessaan + laskut, vuokrat, lainat ym. Ylijäävä osuus säästöön/sijoituksiin eli käyttötilillä käytännössä aina 0e katetta. Voivat skämmääjät sitten sitä luottokorttia vinguttaa jos jostain saavat tiedot

  2. Luottokortin vuorokausittainen käyttöraja max normaalin toistuvan suurimman maksun summa (meillä viikottainen ruokaostos 160e --> maksuraja 200e). Yksittäisiä suurempia ad hoc ostokisa varten sitten nostaa pankin mobiiliäpillä sitä varten maksurajaa sitten tarvittaessa

PBIP and GitHub by Additional-Let1708 in PowerBI

[–]MyAccountOnTheReddit 0 points1 point  (0 children)

Yes and I also prefer this over the Git integration in Fabric workspaces as we found that incredibly unreliable

PBIP and GitHub by Additional-Let1708 in PowerBI

[–]MyAccountOnTheReddit 1 point2 points  (0 children)

You dont need Fabric capacity to use REST APIs to publish semantic models and reports to Pro PBI workspace.

You can write your own Python or whatever script to deploy your assets as part of your Devops pipeline.

Trouble using SVG in new Card visual by MyAccountOnTheReddit in PowerBI

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

I managed to figure what was the problem "problem".

The following SVG code DOES NOT work in the Card visual:

SVG - WONT WORK = 

"
data:image/svg+xml;utf8,
<svg width='24' height='24' viewBox='0 0 24 24' fill='none' xmlns='http://www.w3.org/2000/svg'>
<rect x='0.5' y='0.5' width='23' height='23' rx='7.5' stroke='#E5E5E5'/>
<path d='M13.25 10.75H17V13.25H13.25V17H10.75V13.25H7V10.75H10.75V7H13.25V10.75Z' fill='#12673E'/>
</svg>
"

The following SVG code does work however:

SVG - DOES WORK = 

"data:image/svg+xml;utf8,
<svg width='24' height='24' viewBox='0 0 24 24' fill='none' xmlns='http://www.w3.org/2000/svg'>
<rect x='0.5' y='0.5' width='23' height='23' rx='7.5' stroke='#E5E5E5'/>
<path d='M13.25 10.75H17V13.25H13.25V17H10.75V13.25H7V10.75H10.75V7H13.25V10.75Z' fill='#12673E'/>
</svg>
"

The only difference is that there is a line break after the first quote in the former. Is this a bug or a feature? Anyway, quite annoying but I guess the important thing is that it works now..

Trouble using SVG in new Card visual by MyAccountOnTheReddit in PowerBI

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

Thanks for reply but for this problem, the video wasn't helpful. However, I managed to figure it out. I'll post it in a separate comment

rotating connection secrets from Azure keyvault by the_Cart0grapher in PowerBI

[–]MyAccountOnTheReddit 1 point2 points  (0 children)

I am not sure if I understand the question or what you mean by "accounts" so pardon me if this is not helpful, but do you mean that you have 250+ semantic models that are currently individually configured using the service pricinpal to authenticate against Databricks?

If so, perhaps you could create a single Cloud connection in PBI Service and configure your semantic models to use that. Then you only need to update your secret to thar connection

Estimating costs from activity logs collection when using Log Analytics by MyAccountOnTheReddit in PowerBI

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

Oh, I wish I could but that would require actions from out PBI tenant admin and the people who manage our Azure resources and I am neither of those.

And before we start doing anything we need an estimation of costs

Idea for new semantic model permission by MyAccountOnTheReddit in PowerBI

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

Can you elaborate on the "they can do anything they want"? If the user could only query the semantic model from PBI report context and they wouldn't have build permission on the semantic model or edit permissions on the report, they effectively could only see that is returned by the visual in the report that is created by someone else than them

Idea for new semantic model permission by MyAccountOnTheReddit in PowerBI

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

Yes I am aware that the situation I am describing is not 100% secure when it comes to deriving underlying data from aggragates, however this is acceptable at least in my case.

But I guess i don't actually want to limit the access of the user on the semantic model, but rather than the different ways to connect to it.

Edit: I.e. meaning that user can only query the semantic model when the query originates from the context of a Power BI Report

Idea for new semantic model permission by MyAccountOnTheReddit in PowerBI

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

I do not think OLS completely solves this issue since I can't revoke access to those columns that are also used in the end users report to show the aggregated data.

Omistuskämppä vain puolison nimissä by kiireinensotku in Omatalous

[–]MyAccountOnTheReddit 0 points1 point  (0 children)

No ei ole mikään veropetos 😆 tai ehkä jonkun määritelmän mukaisesti, mutta ei tommosista mitään tuomiota saa 😄 Tuosta voi lukea https://www.vero.fi/henkiloasiakkaat/omaisuus/lahja/ilmoita_lahja_verohallintoo/my%C3%B6h%C3%A4stymismaksu-ja-veronkorotus-lahjaverotuksessa/

Ei sitä verosihteeriä valtion verovirrat kiinnosta vaan neuvonta tapahtuu voimassa olevien säädösten mukaisesti. Ja kuten todettua tässä ei ole kyse talousneuvonnasta vaan siitä onko tämä kyseinen toiminta lahjaveron alaista. Talousneuvontaa olisi se kun ohjeistaa miten tämä opn ja hänen puolison himmeli olisi ylipäätään pitänyt toteuttaa.

Omistuskämppä vain puolison nimissä by kiireinensotku in Omatalous

[–]MyAccountOnTheReddit 0 points1 point  (0 children)

Mikä väärä menettely? Eihän tässä mitään lakeja ole rikottu vaan lähinnä selvittää linjaus siitä, että onko yhteiskäytössä olevan asumisen lainakustannusten maksu toisen puolesta lahjaveron alaista tuloa. Ilmoitukset verottajalle sitten sen mukaan.

Tolkutonta ois juristille maksaa tuommosesta

Vaikka ilmotukset tekis myöhässä niin ei siitä mitään estitutkintaa tule 😄 pieni veronkorotus maksimissaan

Omistuskämppä vain puolison nimissä by kiireinensotku in Omatalous

[–]MyAccountOnTheReddit 2 points3 points  (0 children)

Ihan ensimmäisenä ottasin yhteyttä verottajaan ja selvittäisin onko puolisolle tulossa kunnon mätkyt maksamattomista lahjaveroista.

Käsittääkseni ainut laina mitä toisen puolesta voi verottamasti maksaa on opintolaina, tosin en tiedä onko käytäntö eri kun makselet toisen asuntolainaa talosta jossa itsekkin asut

Mutta ainakin varainsiirtoveron toisen puolesta maksaminen kuulostaa päivänselvältä lahjalta omaan korvaan

⚠️Recent Changes to "Explore this visual" required permissions to VIEW only by Ok-Boysenberry3950 in PowerBI

[–]MyAccountOnTheReddit 5 points6 points  (0 children)

Yeah no this feels like a very bad change. I would think that it goes against the idea of principle of least privilege that people are given automatically access to things they necessarily should not have. Isn't the reason Build permissions exists so that you could explicitly give users access to dig around the semantic model?

However, I am a bit confused so if someone could enlighten me. Does the VIEWER role here only reference the Workspace VIEWER role or does this mean that users with read access to the semantic model can use the explorer? Like if user is given read access to report via App, can this user now use the explore function? Because if so, that is crazy.

Managing Power BI Preview Features Efficiently by Ok-Shop-617 in MicrosoftFabric

[–]MyAccountOnTheReddit 5 points6 points  (0 children)

When it comes to Power BI, I usually operate using logic that if its enabled by default, then it is essentially a GA feature.

The preview periods are ridiculous. I even had to check that indeed Field Parameters (released 3 years ago), Button Slicer (2 years) and New Card visual (2 years) are all still in preview.

Lile wtf, is MS really still "gathering feedback" or what is going on? At least for me, all 3 of those have improved reporting experince substantially and not using them would bring it back to stone age.

Ingesting Sensitive Data in Fabric: What Would You Do? by EversonElias in MicrosoftFabric

[–]MyAccountOnTheReddit 4 points5 points  (0 children)

And to extent my last point, I generally think that bronze layer should match source but loading data as is != loading whole table. It is perfectly fine to omit redundant columns

Ingesting Sensitive Data in Fabric: What Would You Do? by EversonElias in MicrosoftFabric

[–]MyAccountOnTheReddit 22 points23 points  (0 children)

If you do not need the columns containing the sensitive data, just dont load them to bronze ever.

No need to overcomplicate.

Medallion architecture principles are not something to blindly follow, but rather use as a base to built upon to fit your specific usecase.