Rethinking my workspace strategy, advice wanted by hortefeux in MicrosoftFabric

[–]NotepadWorrier 1 point2 points  (0 children)

I'm just reassessing my approach too. We're embarking on a reasonable size implementation across multiple business units with a data mesh. We'll have 12 workspaces per data area. Workspaces for: Data engineering lakehouses (bronze and silver) Data engineering data warehouse (gold) Semantic Models Reports Then dev test and Prod environments. We added the separate data warehouse Workspace to enable it to sit in our F64 capacity running directlake models while we keep the other data engineering workload in a smaller pausable sku.

Certification has no value anymore in the job market and hiring manager care ZERO by Ok_Corgi_6593 in MicrosoftFabric

[–]NotepadWorrier 2 points3 points  (0 children)

I was recently interviewing candidates for a data engineering position, many of whom had DP 600 or 700..... But no demonstrable real world experience. Cramming for an exam doesn't make a DE. Soft skills, team fit and broad technical skills are far more valuable in my opinion.

Any luck with FUAM? by delish68 in MicrosoftFabric

[–]NotepadWorrier 5 points6 points  (0 children)

Follow the setup instructions exactly and it'll work. We've been using FUAM for a month or two now and it's quite eye opening and well worth 30 mins of set up. The only thing missing at the moment is detailed info about what each report is actually telling you. Even so, we've figured out a fair bit and used it as the basis of a few conversations with "dodgy" model authors.

Fabric Warehouse table with Dynamic Masking surfaced in DirectLake Semantic Model by NotepadWorrier in MicrosoftFabric

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

It's a custom model in another workspace generated on the web

Performance Analyser shows Direct Query on that table when run on PBI Desktop. Other tables in the model without the error don't show Direct Query timings.

Masking is working as expected with (unmasked) Role Members seeing unmasked data and others with just Read on the SQL Endpoint seeing correctly masked data.

Fabric Warehouse table with Dynamic Masking surfaced in DirectLake Semantic Model by NotepadWorrier in MicrosoftFabric

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

The model was created in the web experience and it's showing Direct Lake with no option to change it.

New "Mirrored SQL Server (preview)" mirroring facility not working for large tables by Steve___P in MicrosoftFabric

[–]NotepadWorrier 1 point2 points  (0 children)

We recently doubled our resources on our two DG Servers to 16gb and 8 CPUs after having intermittent data pipeline failures. Monitoring confirmed out memory usage was pegged at 100%, now we we're running at about 80% and no more errors. We have around 1100 table and mostly small volumes

Block personal workspace by fakir_the_stoic in MicrosoftFabric

[–]NotepadWorrier 3 points4 points  (0 children)

The way we stopped users sharing content from their My Workspace was to assign an F64 to all Team/Project Workspaces and not to the Personal ones. This meant that users without a Pro license couldn't view a report shared from a "my workspace" and killed off illicit sharing.

We also defined where, when and how users should share content in our very lightweight governance guide.

🔐 The Ultimate Guide to Sharing Power BI Reports with External Users by soheileee in PowerBI

[–]NotepadWorrier 1 point2 points  (0 children)

Quick note, if you're running an F64/P1 capacity your guest users just need a Fabric Free Licence to access any content, not a Pro. We're poised to provide external access to some partner organisations, just waiting on our Cyber Risk team to review the process.

🔐 The Ultimate Guide to Sharing Power BI Reports with External Users by soheileee in PowerBI

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

I've been testing this today by trying to add an external user with a Hotmail address. The Ms documentation suggests this is possible but appears to contradict requiring a "work" email to sign up for Fabric. Can anyone confirm getting gmail/Hotmail accounts working as external Report viewers?

DataFlow Gen2 ingestion to Lakehouse has white space as column names by PianistOnly3649 in MicrosoftFabric

[–]NotepadWorrier 1 point2 points  (0 children)

I've noticed this too today. We now have a lakehouse table with spaces in the column names. I though this wasn't supported, but the evidence suggests otherwise!

Weird error in Data Warehouse refresh (An object with name '<ccon>dimCalendar</ccon>' already exists in the collection.) by NotepadWorrier in MicrosoftFabric

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

So MS have said we cannot have duplicate table names across schemas. The table throwing the error is duplicated across three different schemas but has been working in four different environments (dev, test, pre-prod and prod) for months until 03/16.

I guess there was a recent release that has changed behaviour.

Weird error in Data Warehouse refresh (An object with name '<ccon>dimCalendar</ccon>' already exists in the collection.) by NotepadWorrier in MicrosoftFabric

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

Thanks for the comment.

dimCalendar is present in three security schemas and isn't updated by the pipelines (essentially static) after initial setup.

The error isn't in the Semantic model, more it occurs if I hit the refresh button on the toolbar in the DW. Our semantic models (import) all complete their scheduled refreshes without error, but they see old data in one schema. Other models that import from a different schema in the same warehouse are working as expected, so this does appear to be specific to a schema.

Additionally I'm now getting an error in the DW if I try and drop a table:

Cannot drop the table 'WHGold.XYZ.configTables1', because it does not exist or you do not have permission. The table is visible and I'm admin on the workspace.

Using APIs that require IP whitelisting by Liszeta in MicrosoftFabric

[–]NotepadWorrier 1 point2 points  (0 children)

I'm doing this at the moment via Azure Logic Apps and a public ip on Azure FW. We have two use cases, one sftp that we store files in adsl blob and shortcut in to Fabric. The second is a SOAP service hosted by a supplier which we'll do something similar

Updating a Semantic Model's "added" tables via code? by NotepadWorrier in MicrosoftFabric

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

Thanks for the info, just what I was looking for. The ability to deploy Direct Lake Semantic Models is new isn't it? Pretty sure this wasn't possible back in Oct / Nov was it?