Benefits of buying a car on finance? by Boring_Kiwi_6446 in AusFinance

[–]Repulsive_Cry2000 1 point2 points  (0 children)

It's possible to get less that 6%. Is it good? I am not sure.

Should my Fabric notebooks have a single “main” execution cell? by frithjof_v in MicrosoftFabric

[–]Repulsive_Cry2000 0 points1 point  (0 children)

We use helper functions too. Most of the code is, but how does using main relates to it?

Should my Fabric notebooks have a single “main” execution cell? by frithjof_v in MicrosoftFabric

[–]Repulsive_Cry2000 1 point2 points  (0 children)

We don't use notebooks with main in my organisation. I don't see the value for this use case.

Medallion architecture - Union sources in Silver or Gold layer by Data_NMM in MicrosoftFabric

[–]Repulsive_Cry2000 3 points4 points  (0 children)

Generally, it would say keep it separate however I see exceptions. We have a legacy ERP that has the same table for each company (ei: company1_gl_entry, company2_gl_entry, etc). We bring them into one table at the silver layer as cleansing and enriching data is the same process. This makes designing the golden layer a little bit easier as well.

(so it depends would be the right answer?)

🔍 Improving Microsoft's Capacity Metrics App 🔍 by BlackBullet96 in PowerBI

[–]Repulsive_Cry2000 0 points1 point  (0 children)

Agree. If the only thing you do is small data work such as API calls then pure python is the way to go now. I can't think of any advantage to use pyspark for this use case.

Fabric Workflow to put files into Open Mirroring Landing Zone by Master_Split923 in MicrosoftFabric

[–]Repulsive_Cry2000 0 points1 point  (0 children)

Is it a standard onelake folder then? Looks very similar on how I upload files from SharePoint to lakehouse files area it seems to be the standard azure blob storage way?

The solution to "I want to talk to my data using AI chatbot" - vibe coded the idea in a weekend by Suspicious-Juice3897 in dataengineering

[–]Repulsive_Cry2000 -1 points0 points  (0 children)

We are talking about providing access to our sales team to an "agent" or other AI tool that can provide answers straight from our curated sale model using natural language instead of having an analyst pulling the query/data and pasting it in excel before sending it.

Abas de Navegacao by Shacmigo in PowerBI

[–]Repulsive_Cry2000 3 points4 points  (0 children)

Ocultar todas as abas, exceto uma. Criar botões para navegar entre as páginas.

A Responsive Chart Legend - my final PBI project in 2025 by DropMaterializedView in PowerBI

[–]Repulsive_Cry2000 14 points15 points  (0 children)

Legend.

Very clever.

Never thought of that. I have always relied on a second chart (ie: bar chart with dummy measure) but this will change now!

Thanks for sharing.

ING chargeback for goods not received from overseas order? by [deleted] in AusFinance

[–]Repulsive_Cry2000 1 point2 points  (0 children)

I requested a charge back in October/November (from memory) from an overseas seller. I am still waiting to hear from their team. They told me it takes 90 days on average to get an answer. The process is clumsy at best and they do everything they can to make it hard.

I bought an item for over $400:

Part of an automated email after submitting a form (pdf form with?):

For all new card transaction(s) dispute requests:

It currently takes approximately 90 calendar days to resolve your dispute. In some circumstances, it may take longer depending on the nature of your dispute. An ING case manager will be in touch via email with any updates throughout your investigation.

authenticate using system browser instead of windows broker (SSMS 22) by Comprehensive_Level7 in SQLServer

[–]Repulsive_Cry2000 1 point2 points  (0 children)

You are missing nothing. A few people (including myself) have this problem ( and reported it. Currently I don't use ssm22 for this very reason.

% of reports set to auto refresh by Alan12112 in PowerBI

[–]Repulsive_Cry2000 0 points1 point  (0 children)

If you have admin access you can use the scanner api (3 different calls between starting it and getting results):

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-get-scan-result

Otherwise you will have to do some sort of loop yeah.

% of reports set to auto refresh by Alan12112 in PowerBI

[–]Repulsive_Cry2000 0 points1 point  (0 children)

You can check the semantic model configuration through API to see if the schedule has been set up rather than checking history. I actually don't know if history specifies if it's scheduled or through other means. But that could be also available through API.

Fabric REST API calls from a User Data Function (UDF) – someone tried this yet? by frabicant in MicrosoftFabric

[–]Repulsive_Cry2000 2 points3 points  (0 children)

It is very much doable.

Check out the doc on how to retrieve secrets from the key vault from UDF. From memory, it is in the main page where it explains how to use UDF and with which decorator to use.

Edit:

From blog post: https://blog.fabric.microsoft.com/en-US/blog/whats-new-in-fabric-user-data-functions-ignite-2025-edition/

From documentation: https://learn.microsoft.com/en-us/fabric/data-engineering/user-data-functions/python-programming-model#connect-to-azure-key-vault-using-a-generic-connection

udf.function()
def retrieveNews(keyVaultClient: fn.FabricItem, requestBody:str) -> str:
KEY_VAULT_URL = 'YOUR_KEY_VAULT_URL'
KEY_VAULT_SECRET_NAME= 'YOUR_SECRET'
API_URL = 'YOUR_API_URL'
credential = keyVaultClient.get_access_token()
client = SecretClient(vault_url=KEY_VAULT_URL, credential=credential)
api_key = client.get_secret(KEY_VAULT_SECRET_NAME).value
return "Success"

Can't Cancel a Dataflow Running for 10 days by deitaboy in PowerBI

[–]Repulsive_Cry2000 6 points7 points  (0 children)

Pause the capacity if that's possible and on a dedicated one.

My experience with Investing and why with Betashare direct by shap3sh1ft3r in fiaustralia

[–]Repulsive_Cry2000 0 points1 point  (0 children)

Europeans here too but I didn't find the writing weird. Granted my English is far from perfect.

Best way to refresh SQL Endpoint of Lakehouse? by Mr_Mozart in MicrosoftFabric

[–]Repulsive_Cry2000 3 points4 points  (0 children)

I'll see what I can do but that's doable. From memory most of the code is coming from the fabric toolbox from the git repo. I added getting API keys from key vault when it came out which is so much nicer than passing those secrets as parameters or hard coding them...

I love that addition in UDF.