u/Personal-Quote5226

Allow apps running outside of Fabric to access data via OneLake

Allow apps running outside of Fabric to access data via OneLake

Is there a reference that indicates specifically what is 'cut-off'.

Is it all of the APIs, lakehouse endpoints, and SQL Analytics Endpoint? It blocks that access?

This setting has a very non-technical explanation of the access it blocks.

Allow apps running outside of Fabric to access data via OneLake

You can allow or restrict access to OneLake data from applications that are outside of the Fabric environment. Admins can find this setting in the OneLake section of the admin portal tenant settings.

When you turn on this setting, users can access data from all sources. For example, turn this setting on if you have custom applications that use Azure Data Lake Storage (ADLS) APIs or OneLake file explorer. When you turn off this setting, users can still access data from internal apps like Spark, Data Engineering, and Data Warehouse, but can't access data from applications running outside of Fabric environments.

u/Personal-Quote5226 — 1 day ago

Cannot create new environments in Fabric

We get this error when trying to create a new environment in a workspace.

Tons of compute available on an F16.

Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits. Try again later.

Is this a bug?

There are two ways we can create an environment.

Add Items. When we do that, we only get a weird blank square that doesn't go away:

https://preview.redd.it/stjs5b5pdc2h1.png?width=1046&format=png&auto=webp&s=d14643ce9d0803965bfd043e6ed80c9a508199b9

When we add environment through the Notebook 'environments' drop down, we can enter an environment name, but we get this error:

Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits. Try again later.

Tons and tons of compute available.

Is this a bug that others can reproduce? Something wrong with our environment? A setting I'm overlooking?

reddit.com
u/Personal-Quote5226 — 1 day ago

Prevent Workspace Users from Accessing underlying Lakehouse schemas, files and data

We need some users to have permissions at the workspace level. Even the very lowest permission (Viewer) allows the user to view Lakehouse data via the SQL Endpoint of all Lakehouses in the workspace while Contributor and higher give you ReadAll to the Lakehouse, and access to schema/files/data.

We need users to have the ability to view the workspaces (navigate it, see items/notebooks/pipelines/etc); this is for administration, auditing, etc. However, these same users aren't business users and we don't want them to see any data whatsoever.

Is there a recommended approach to achieving this?

Update: The SQL Analytic endpoint can be restricted by using SQL policy on the underlying schema or tables (ex: DENY) .
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-granular-permissions

u/Personal-Quote5226 — 2 days ago

[Can't change the subject -- I'm looking for user/security context that the pipeline ran under... ]

The only field that comes close is 'submitted by' when I look in the monitor tab, but this is incorrect as it represents the user who ran/executed the pipeline rather than the security context the pipeline ran under...

reddit.com
u/Personal-Quote5226 — 15 days ago

Any news on when we will be able to run a data factory pipeline under WI or SPN.

The option right now are very limited....

1-We are looking at using a service account (the account will maintain 'ownership' of the pipelines and always be the 'last modified user')

2-Use Jobs REST API to invoke.

How do you guys approach this currently?

reddit.com
u/Personal-Quote5226 — 15 days ago

I'm implementing a dashboard and we want Parent / Detail visuals.

So, we have a parent visual (in this case a Matrix); when we click a Matrix row, it's properly filtering what we consider to be the child table visual and showing related row details on it.

We've edited the available interactions (none).

However, when we click on one of the rows in the detail (table) visual it then re-sets its own filter and shows everything.

That's not the experience we want. We also don't want to be beholden to using ctrl/command row click to not lose the filter.

What's missing here? Or is there a more appropriate way for us to implement a proper parent / detail dashboard that doesn't reset the second someone tried to interact with the detail visual?

reddit.com
u/Personal-Quote5226 — 19 days ago

Frequently changing the result of a measure in PowerBI semantic model.

However, it never updates again properly on the report. Sometimes eventually it will start working if we open and close the PBI report a few times, open and close the Semantic Model. Refresh. And do that for a bit and hope it fixes it.

Sometimes it does.

Sometimes it doesn't and a significant amount of time passes where the only solution is to remove the old measure on the dashboard and re-add it. Annoying issue there is we have to re-set all of the settings on that field in the visual.

What's the normal way to get this to update and reflect properly on the report without having to remove the measure and re-add it?

reddit.com
u/Personal-Quote5226 — 19 days ago

Could someone help me with an understanding of what PowerBI Matrix is actually thinking behind the scenes here...

ProductSalesFact

DateKey
ProductID
QtySold

Then there is a join to a Product Table Dim (1:many from Product to ProductSales)
ProductID
ProductName

Then there is a join to a WarrantyCases fact table (1:many from Product)

ProductID
WarrantyCaseNumber

I can put this into a matrix...

And it works correctly.

I a single column for each product, the value is QtySold, then each row is a date key.

Perfect.

When I add a measure directly to ProductSalesFact which basically will provide the Sum of WarrantyCaseNumbers, that displays correctly in the Matrix now too, whereas I get a Product column for each product with 2 sub columns (QtySold, and Sum of Cases)

However, in inexplicably adds a blank column to the beginning of the matrix representing an empty Product name and empty QtySold and Sum of Cases.

Based on the joins and the data, I don't understand how suddenly empty Product rows can be produced here which result in those empty columns on the visual.

What is happening technically behind the scenes in PowerBI to make PowerBI think that there is now an empty product that has to be displayed on the visual?

reddit.com
u/Personal-Quote5226 — 19 days ago

There are a few clunky ways to do this, and I've seen teams spend 6 hours on this and still not get it to work.

Any chance there is a new feature coming that will allow us to hide come columns in a Matrix with a click or a setting?

When you have the header level values you want in a column they repeat per group, but because it's a header/row level value the value is always the same per group. So, we just want to hide it and put it in the summary column.

Something like this shouldn't require reading a manual and 5 you tube videos in order to come up with a hacked approach using column widths or calculation groups :)

Thanks....

reddit.com
u/Personal-Quote5226 — 20 days ago

Large semantic model. Already developed. Lot's of measures added and DAX.

We want to use DirectQuery instead of DirectLake.

Is there an easy way to just take this semantic model and rebind to the same tables but using Direct Query?

reddit.com
u/Personal-Quote5226 — 20 days ago