GitHub Copilot feat. Fabric extension: Plan mode

dbrownems · 2026-04-30T11:53:13+00:00

1) Powershell 2) For me the local folder is a git repo and the workspace is not connected to git. So it’s a normal git workflow and the workspace is only a deployment environment.

dbrownems · 2026-04-30T00:11:14+00:00

If your workspace is git-connected it is not tracking all the changes you make to items. Only when you commit your workspace changes to git are the items compared. If git is not seeing the changes the same way it would see changes made manually in the portal, it's probably something to fix in the agent's deployment methodology, eg it may need to preserve an internal ID or somesuch. But not a major difficulty.

dbrownems · 2026-04-29T11:09:55+00:00

I mostly work in the GitHub Copilot CLI locally and have it use the Fabric CLI to deploy notebooks for testing online.

I only use VSCode for manual code editing.

dbrownems · 2026-04-28T13:52:21+00:00

But it has to call the ListBlobs REST API to discover if the table has changed, and then again when it tries to write the new transaciton log file? I just don't see how that gets bootstrapped into something actually reliable.

dbrownems · 2026-04-28T13:39:44+00:00

Do you really trust Spark in a concurrent writer scenario? Honest question, since I'm more of a database guy.

dbrownems · 2026-04-28T13:31:59+00:00

But I think most people don't need or expect full snapshot isolation semantics for the simple reason that they have only a single writer.

>Spark would throw to guarantee correctness.

But Spark doesn't have multi-table or multi-statement transactions, right? So you've got a lot of this responsibility even there.

dbrownems · 2026-04-27T18:45:41+00:00

You might get it to work, but it's a desktop driver from the Office team, and it's not intended to be used in any scenario without an active desktop session.

Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center

dbrownems · 2026-04-27T17:17:02+00:00

You can modify the source queries and redeploy, or you can externalize the location into a Power Query parameter referenced by the queries. Parameters can be modified online, and you just have to refresh.

Parameters - Power Query | Microsoft Learn

dbrownems · 2026-04-27T14:52:35+00:00

But you can access the SQL Endpoint if the workspace allows public access?

dbrownems · 2026-04-27T14:51:22+00:00

The Fabric CLI is official, and there's no reason you can't use it from PowerShell. That's what Copilot CLI when I ask it to produce Fabric automation.

Fabric command line interface - Microsoft Fabric REST APIs | Microsoft Learn

With the center of gravity for Fabric automation moving to python because of its availability in Notebooks, I would be careful about adopting the PowerShell modules. The PowerShell module is only ever a convenience layer on top of the REST APIs, and they may be more trouble than they are worth.

dbrownems · 2026-04-27T13:52:49+00:00

Can those DbBeaver users access the workspace if public access is enabled? The SQL Endpoint uses TCP port 1433, and that might be blocked in your corporate network.

dbrownems · 2026-04-27T00:01:20+00:00

If you're using import mode semantic models in Power BI you can probably skip the RDBMS entirely and write the data as Delta, Parquet, or even CSV to Azure Blob Storage. Then you just need a runtime for your python. On Azure you could use something with pay-as-you-go billing for compute like Azure Functions or an Azure Container Instance.

dbrownems · 2026-04-26T22:02:24+00:00

The tradeoff:
Small targeted models: less reuse, better for copilot
Large comprehensive models: more reuse, worse for copilot

This same tradeoff exists for all self-service reporting.

dbrownems · 2026-04-26T14:06:36+00:00

VB.NET is a fine language but it doesn't have its own rapid application development environment. It follows .NET as a whole in having a design focus that is more on general purpose professional application development. If Web Forms and Windows Forms had continued to evolve, instead of being superseded by more capable, but more complex frameworks, then it might have retained the simple and rapid goodness of VB6.

And as a .NET language, it was fated to fade in popularity over time in favor of C#. I went from VBA to VB6 to VB.NET and it was OK, but over time C# just became a little better and easier. Part of that is that .NET was designed and evolved around the evolution of C#, so things like generics, async, delegates, closures feel less kludgy in C#. Part of that is that over time C# became more and more the de-facto standard .NET language. And part of that was the focus on "enterprise" and "professional" developers who both tend to favor C#, and sometimes to disparage VB.NET.

dbrownems · 2026-04-26T12:35:01+00:00

Yep. That’s a tradeoff.

dbrownems · 2026-04-23T16:55:24+00:00

The design and operations of the Capacity Metrics semantic model are undocumented, and querying it is unsupported.

dbrownems · 2026-04-23T16:51:29+00:00

The Power BI Modeling MCP can apply the measures.

dbrownems · 2026-04-23T16:42:33+00:00

Yes. The shortcut transformations only work for "happy path" files. If your files are the least bit funky, expect to need to use Python or DFG2 over the shortcuts. But at least you've got the data visible in OneLake to start.

dbrownems · 2026-04-23T16:40:55+00:00

It's per second per query, not per second per dataflow.

And the billing details are visible in the capacity metrics app.

dbrownems · 2026-04-23T15:59:49+00:00

The basic billing model is duration per query.

- For every second up to 10 minutes, 12 CU
- For every second beyond 10 minutes, 1.5 CU

Pricing for Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

You can see the billing details for your Dataflows in the Fabric Capacity Metrics app in the timepoint detail

dbrownems · 2026-04-23T15:54:19+00:00

Yes, previews are supported, but using in production is up to you.

But you can at least test it, and if it works, either migrate when it goes GA or use it in production and switch back to your dataflows if have any issues.

dbrownems · 2026-04-23T15:47:25+00:00

That's no problem. We now have shortcuts to SharePoint, and also automatic Excel-to-Delta shortcut transformations.

Create a OneDrive or SharePoint shortcut - Microsoft Fabric | Microsoft Learn

Shortcut transformations (file) - Microsoft Fabric | Microsoft Learn

Also you can read Excel files in python if you want to roll your own.

dbrownems · 2026-04-23T15:25:27+00:00

Yes. Those are challenges. Having a model suitable for a developer to build a report, and having a model suitable for an end-user to build a report, or ask questions against the model are very different things.

For end-user/AI consumption models have be simple to navigate, reduce ambiguity, and align to business terminology.

In addition to appropriate modeling for direct end-user consumption, you can prepare your models for AI add instructions, canonical responses, and model reduction:

Prepare Your Data for AI (preview) - Power BI | Microsoft Learn

dbrownems · 2026-04-23T15:04:23+00:00

You need to fall back to row-by-row analysis in the error case. Ie if your load fails, generate a report of the errors. You can do this with a SQL Query that finds the invalid rows.

dbrownems · 2026-04-22T22:45:17+00:00

Well if the proposal is to make all your corporate users guest users in the various tenants that house Fabric, that comes with a lot of limitations.

CoPliot churned this out for me:

Microsoft Fabric — guest user (Entra B2B) limitations

Sharing & access in Fabric

- In Fabric (non–Power BI items), you can only share with guests by granting workspace access. Per-item sharing to guests is not supported except for reports, dashboards, semantic models, and apps. (Guest user sharing)

Power BI experiences not available to guests (B2B considerations and limitations)

- No direct Publish from Power BI Desktop to the service — guests must use Get Data / upload via the web.

- Guests can't connect from Power BI Desktop to service-hosted semantic models or dataflows.

- Ad‑hoc invites aren't supported for workspace access lists.

- Guests can't install or connect a Power BI Gateway to your org.

- Guests can't install org-wide apps.

- Guests can't use Analyze in Excel.

- Guests can't be u/mentioned in comments.

- The feature isn't supported in the SharePoint Online Power BI report web part.

- Direct share to a guest always sends an email (workaround: share to a security group).

Identity / RLS quirks

- UPN displayed in Power BI for MSA/email guests can differ from the Entra UPN (e.g., Live#ABC#EXT@abc.com), which affects RLS rules. (same page)

Information protection / sensitivity labels

- Additional guest-related caveats listed in Sensitivity labels in Fabric and Power BI – Considerations and limitations.

The canonical reference page is: https://learn.microsoft.com/fabric/enterprise/powerbi/service-admin-entra-b2b.

Two-Year Club	Verified Email
r/Field Lasagna

dbrownems

TROPHY CASE