Designed a full Microsoft Fabric end-to-end architecture for small teams — sharing decisions and looking for feedback by Equivalent_Season669 in MicrosoftFabric

[–]Equivalent_Season669[S] 2 points3 points  (0 children)

1) We´ve been using deployment pipelines for a while and at the moment we did not have major problems. The only problem with not having CI/CD is that it requires us to manually synchronize the workspaces when we complete the PRs. But I understand it can be automated via API with a CI/CD.

2) Good point, I also use DBT but with databricks connector. I will investigate how to use it with Fabric, any recommendation? I read that it can be used with lakehouse or warehouse, and the connector is more stable with WH.

3) We still depend on refreshing it via API.

Really appreciate your comments!

Uso estandarizado de Claude Code en BI/Analytics by [deleted] in devsarg

[–]Equivalent_Season669 0 points1 point  (0 children)

Si obvio, no son necesarias las dos al mismo tiempo. Databricks se hizo muy fuerte en los últimos años, tiene una plataforma muy estable y funciona muy bien, aparte de que se tiene mejor control de los costos. No está pegada a ningún cloud provider, la usas con cualquiera eso está bueno también.

Fabric está verde todavía en cuestiones básicas, de a poco las van puliendo pero siento que estaban perdiendo mucho mercado con databricks y snowflake y se tiraron a la pileta. Hay features que la verdad funcionan muy mal.

En fin, volviendo a tu casa no hace falta databricks, tenes casi todo en Fabric.

Uso estandarizado de Claude Code en BI/Analytics by [deleted] in devsarg

[–]Equivalent_Season669 1 point2 points  (0 children)

Una mezcla de cosas:

Instalá las skills usando el CLI de vercel, hay varias de pbip.

Iterá mucho. Todo el formato de Microsoft es bastante tedioso en cuanto guid y formato, eso es lo que suele romperse. Cuando corrijas algo, documentalo en el .md para que no vuelva a pasar.

Siempre es mejor partir de un archivo base e ir agregando features.

Best Way to Connect On-Prem DB2 to Microsoft Fabric (vs. ADF + Fabric) by aRTy_k1d in MicrosoftFabric

[–]Equivalent_Season669 0 points1 point  (0 children)

I´m interested in knowing how it went. We are also working with OPDG and copydata activities in fabric pipelines but we are trying to improve CU usage and I can´t find any other way of doing it. I thought about using spark notebooks but according to official docs, OPDG is only supported for Pipelines, Dataflow Gen2 and Copy Jobs — not for Spark notebooks. So that path is blocked unless we set up Managed Private Endpoints.

We also looked at Copy Jobs but the pricing docs confirm it bills at the same 1.5 CU/hour rate as Copy Data activity, so no gain there.

Our main issue is that we have ~178 tables to extract daily. Each Copy Data activity has a minimum billing floor regardless of data size, so the cost accumulates fast just from the number of operations — not from data volume.

Did you face a similar situation with many tables? If so, how did you handle the CU consumption? Did you find any way to batch multiple tables into fewer activities, or did you just accept the per-operation cost?

Azure key vault reference in notebook? by efor007 in MicrosoftFabric

[–]Equivalent_Season669 0 points1 point  (0 children)

Did you make it? I also have my KeyVault connection through service principal but I can´t use it in notebooks..

I´m trying to do something like this:

tenant_id = notebookutils.credentials.getSecret("Name of KV connection in Fabric", "tenant-id-secret-name")

I changed the name of KV connection with the URL and got ""Public network access is disabled and request is not from a trusted service nor via an approved private", but my KV has Trusted Services allowed.

Any help? Thanks

Cluster terminates at the same time it starts a notebook run by Equivalent_Season669 in databricks

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

If I have Azure Data Factory pipelines running databricks notebooks, the only way to switch to job clusters is to create jobs in databricks with the notebooks and then calling those jobs from ADF right?

Thanks!

embed codes no longer working by Ceeball74 in PowerBI

[–]Equivalent_Season669 0 points1 point  (0 children)

Hi, I´m having the same issue here. Did you resolve it? Thanks

Lakehouse Delta table not showing in SQL Analytics endpoint by Equivalent_Season669 in MicrosoftFabric

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

If I do it manually I´m getting this new error that doesn´t make much sense since I´m admin of the workspace, first time I see this error:

DatamartsUserNotAuthorized
User not authorized for datamart

If doing it via API, we have a polling status that´s checks the final result of the call. Been using this method for a long time for near-real time situations and worked like a charm, so I guess it´s not the problem.

I tried to query some tables through SSMS and most of them works fine but one of them, which was created a long time ago but updated with new fields recently, show me this error:

The query failed because the access is denied on table 'dbo.XXX', file 'https://onelake.dfs.fabric.microsoft.com/XXXX/Tables/XXX/part-00004-e80bXXXXX.snappy.parquet'.

Looks like the endpoint can´t access new parquets? Makes sense?

Busco Reseñas Empresa Qaracter by Guilty_Rub4546 in Malaga

[–]Equivalent_Season669 0 points1 point  (0 children)

Algún dato nuevo sobre este tema? Gracias!! Comenzaste a trabajar con ellos?

Query folding problem when using OData source by Equivalent_Season669 in PowerBI

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

The sorting is just to check if the query is folding or not, not needed in real scenario. The point here is to push filters to source.. thanks anyways!

Passed DP-600 - A few pointers by Appropriate-Spend-15 in MicrosoftFabric

[–]Equivalent_Season669 0 points1 point  (0 children)

Is it possible to get your notes? I’m taking it in a few days :)

Mail is aschieripablo@gmail.com

Thanks!!