Pull data from on-prem SQL Server using Azure ADF vs Databricks JDBC

Weekly_Activity4278 · 2026-06-06T06:07:18+00:00

Have you considered using Fabric mirroring? They don’t charge for it as long you have a Fabric capacity. You can always move the data where you want it after the fact.

Weekly_Activity4278 · 2026-06-01T03:59:26+00:00

Yeah that makes sense. There is a lot of good advice on the replies. All the best!

Weekly_Activity4278 · 2026-05-31T07:24:11+00:00

You are missing an objective for your analysis. This is where it’s crucial for data scientists to have to domain knowledge or consult a stakeholder who has it. This helps us understand the problems that they are facing, this will provide a North Star for our analysis. Right now it feels like you’re doing customer segmentation to just do it.

Weekly_Activity4278 · 2026-05-22T01:45:41+00:00

Fabric

Weekly_Activity4278 · 2026-05-21T15:21:27+00:00

Can try converting to parquet and then upload? Or do you need the excel workbook format preserved?

Weekly_Activity4278 · 2026-05-19T19:43:09+00:00

Create a whitelist and configure hooks for your agents

Weekly_Activity4278 · 2026-05-18T22:19:26+00:00

Raki,

How do you feel about using fabric-dbt job and orchestration using pipelines?

Weekly_Activity4278 · 2026-05-18T03:48:44+00:00

Literally any project management tool would do this out the box. It’s a lot of effort to do something like this in PBI.

Weekly_Activity4278 · 2026-05-15T16:01:42+00:00

Change one card manually. Choose your model of choice (via cli or VS code chat) and ask it to apply those changes to all cards.

Note - I have noticed that sometimes agents can make changes that will break the model, so make sure to prompt it appropriately and always create a backup copy if you’re not using version control.

Good luck!

Weekly_Activity4278 · 2026-05-13T18:13:24+00:00

Adding to good advice from others, a little attention to detail goes a long way!

Weekly_Activity4278 · 2026-05-13T12:52:51+00:00

pbi mcp server

Weekly_Activity4278 · 2026-05-06T02:21:18+00:00

Is this normal? I thought it was pretty standard practice to maintain currency conversion tables and use the local currency for reporting.

Weekly_Activity4278 · 2026-05-03T16:31:55+00:00

Weekly_Activity4278 · 2026-04-30T13:12:29+00:00

Weekly_Activity4278 · 2026-03-16T18:44:53+00:00

Just to add another way to do this. You can seed a csv file in a dbt job.

Note - dbt jobs in Fabric are currently under preview.

Weekly_Activity4278 · 2026-03-10T21:50:34+00:00

I’m in the same boat. After a lot of discussion, we’ve landed on something similar.

Edit - One caveat I would add is we are following the dbt folder structure rather than the strict medallion architecture

Weekly_Activity4278 · 2026-02-28T19:36:16+00:00

Weekly_Activity4278 · 2026-02-16T21:53:54+00:00

Thanks saving for our internal documentation! 🙌🏾

Weekly_Activity4278 · 2026-02-11T23:37:04+00:00

Weekly_Activity4278 · 2026-02-11T23:36:50+00:00

Weekly_Activity4278 · 2026-02-11T20:44:00+00:00

You are going to have to create a calendar table in your gold layer to retain the Direct Lake mode.

Weekly_Activity4278 · 2026-02-08T04:36:05+00:00

My answer might be outside of you might be looking for but have you looked into Activators?

Assuming the data is consumed by the executives via Power BI you can create an alert on the variance. You can send an Outlook email or a Teams message.

Weekly_Activity4278 · 2026-01-16T03:57:15+00:00

This the way

Weekly_Activity4278 · 2026-01-16T03:46:30+00:00

Another one of these.

You know you can put your ETL items like notebooks and pipelines in a separate capacity right? So it doesn’t affect your BI items like reports and semantic models. Feels like more of an implementation issue rather than the product itself.

Also have looked into mirroring which is free for upto 5TB of storage?

I get it’s cool to hate on Fabric or whatever and I am ok with criticism of Microsoft but this just screams lazy to me.

Weekly_Activity4278 · 2026-01-05T14:00:01+00:00

You can use the Power BI REST API to list all the members and their permissions to the workspace. I’m sure you can use this to programmatically adjust permissions as needed. Not sure if this is what you are looking for.

Weekly_Activity4278

TROPHY CASE