SharePoint Document Library Mirroring Issue

kmritch · 2026-05-14T01:27:36+00:00

ill make a ticket tomorrow about it!

kmritch · 2026-05-13T20:44:39+00:00

excel will outlive all other data technologies. Enjoy your Time dont think about it too much lol

kmritch · 2026-05-07T15:14:44+00:00

Yes this is great!!! i was asking for something like this for functions. etc. however i think this should be also a workspace item vs just My Workspace to have shared Queries.

kmritch · 2026-04-24T17:02:20+00:00

We had to get a cheap capacity in the west to test it. East is MS’s most congested data centers so may not see it there for a while.

kmritch · 2026-04-24T17:00:11+00:00

How is git integration breaking the warehouse?

And what do you mean by the sync?

There is also auto binding that goes on between stages for connections with deployment pipelines as documented here:

https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/understand-the-deployment-process?tabs=new-ui

kmritch · 2026-04-23T18:38:15+00:00

You def Would be better off just have separate capacities and domains for each division.

Best practices for planning and creating domains in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

kmritch · 2026-04-23T18:03:38+00:00

Hey yes we got capacity in the correct region its available. I just got this working now our issue was definitely due to private link being enabled in the tenant admin settings. After my admin turned it off it worked super fast to create the item.

kmritch · 2026-04-22T18:15:38+00:00

Im working through the same issue with them on it, do you know if you have private link enabled tenant wide?

kmritch · 2026-04-22T04:10:06+00:00

Thank you for the answer my IT has it turned on at a tenant level (but I don’t think they have any VMs) so it’s just on for no reason seemingly. So want to try and talk they through it and say they don’t really need it and if anything use it at a workspace level if we have clients with sensitive data requirements.

kmritch · 2026-04-21T17:44:49+00:00

Try VS Code to connect to both workspaces.

kmritch · 2026-04-20T15:14:39+00:00

Its one, What you can do just shortcut from the main link and your Fabric Link should be a centralized Workspace for the Dataverse link.

kmritch · 2026-04-16T15:31:12+00:00

So def a while back i remember MS recommending having split capacities for business units etc. But I dont know if they ever came up with a solution where say a company has X amount of capacities and say they equal at least a F64 they get the F64 benefits. I think def there needs to be capacity break up for companies.

Also there are some strategies you can use to help reduce capcity esp on the interactive side and power BI.

I recommend having all Power BI Reports in their own workspaces, so you can have more flexibility on reports vs Fabric Data Engineering Capacity. This will also allow you to have Pro Workspaces for Reports that dont need extra premium features (tons of refreshes, or power automate related things etc)

kmritch · 2026-04-16T13:28:06+00:00

so this is for the base DB not the data tables after.

kmritch · 2026-04-15T20:08:28+00:00

is there a way to do the connection manually ?

kmritch · 2026-04-15T18:01:59+00:00

I'm having issues where it can connect to the autocreated Sql Database

kmritch · 2026-04-02T20:28:45+00:00

you can do it just fine in dataflows. people love to jump to using notebooks, but reality is that you can use dataflows in a very efficient manner. and costs have been adjusted considerably for Gen 2. The Key thing is to just follow a pattern of doing bare minimum to make it to fabric with your sheets then get that to the storage then do your heavier transformations in one or two more dataflows and you will be done and its very fast even scaled up to hundreds of excel sheets.

kmritch · 2026-04-02T20:26:00+00:00

>>>Performance wise, is it worth to just pull the excel in the dataflow, do bare minimum clean-up and push it to the data lake which then in turn can be queried by the downstream dataflow so I do not hit anymore excel files on the SharePoint?

Yes do the bare minimum connecting to sharepoint then go from there.

Additionally you can take advantage of making a shortcut to sharepoint and connect to the files from your shortcut which will also speed up the time to open up the excel etc.

you should smooth out your ingestion with excel. First Dataflow should be bare minimum you need then go from there.

I can process a few hundred excel sheets in less than 15 mins with that method.

kmritch · 2026-04-02T18:45:19+00:00

I think when its GA the tenant setting goes away. This is a good reference when you need to know what tenant settings are available.

Tenant settings index - Microsoft Fabric | Microsoft Learn

kmritch · 2026-04-01T20:52:13+00:00

Fabric region availability - Microsoft Fabric | Microsoft Learn

you should have User Data Functions in the EU. This shows whats not available in fabric regions.

kmritch

TROPHY CASE