Hi @VictorLojero  can you please elaborate your ask?

If you are a tenant admin, you have a robust report in OneLake Catalog - Govern tab

click 'View more' and there you can explore the data in your tenant.

for example, filtering on 'reports' in the 'feature usage' tab you can see what activities were taken and in which report

additonally, per report, you have 'usage metrics report' (assuming its enabled in your tenant through tenant settings). there you can see how many users accessed the report and track some metrics around that.

Thanks @ITmerrr  for submitting this idea

as we are working on enhancements to Admin Portal, I'd be happy to better understand:

- Tenant settings - would you expect non admins to be able to access that page? those non admins will be able to change settings? will be happy to learn more about this use case

- usage metrics - that's a deperecated tab, we removed it, the change is rolling to production

- premium per user - is setup - would you expect non admins to be able to change it?

- Audit logs and Users redirect to external system (M365 ) - same quetsion , what would you expect the non admins to be able to see here?

You can use a DQ connection instead.

Thanks for the input.

Trying to understand the scenario better - what would be the reason for doing this?
Eventhouse data and OneLake Availability is considered as one logical copy with same access level and retention. You can query the data in OneLake without using the Eventhouse compute for historical analysis, while querying the Eventhouse direcely for timeseries/real-time analytics.

If you would like to manage the data in lake seperately, then copying it outside Eventhouse might be a better way think about it. 

Just trying to get more clarity on what the ask is or what sort of scenario y ou envision for this, would you say that this is more about comparing the schemas rather than the data of both tables?

Today you can use functions such as Table.Schema to get the schema of both tables and compare the two schemas.

What sort of comparisons or outcome would you like to see? do you have any examples of what would help you the most in terms of structure of the response in the event that there was a simple function that could take a list of table queries?

Given that Dataflow Gen2 (CI/CD) offers GIT integration so you can commit your changes and go back in time to a previous commit, what are the scenarios where not having an undo today are hindering your experience?

Do note that within some dialogs, like "Add custom column" or even in the "Advanced editor" and the "Formula bar" we do have some undo support for the text that has been entered, deleted or modified.

In order to compute each step, we require to send the request to your source. Turning it off would mean that we wouldn't be able to communicate with your data source and validate that the request is valid. Imagine a scenario in which you manually type the name of a value which is incorrect and we aren't able to filter your table to say that there are no values with that string in your column. This wouldn't be possible to compute solely on the data preview as the preview typically only holds around 200 rows unless you start scrolling further down.

If perhaps the idea is more geared towards creating a local cache of your data and only working against that cached and sampled dataset, definitely feel free to edit your idea to fit such description.

We recommend using either one of the two features below to reduce the number of requests as well as the load to your data source:

Using Schema view (Preview) - Power Query | Microsoft Learn - this makes sure that you only work with your table schema and are not loading anything other than just the schema

Preview only step in Dataflow Gen2 (Preview) - Microsoft Fabric | Microsoft Learn - you can set a filter against your data to, fundamentally, work on a sample of your while authoring your dataflow without ever impacting the end-result which would go against the unfiltered dataset.

have you tried using BYOLA for analysis services?  This is the recommended way of obtaining memory data for AS.

Given the latest response in the comments, I'm removing the Dataflow label and adding the Pipeline one so the Pipelines team can investigate a bit further as to what the true ask is here.

If this is a support case, I highly recommend reaching out to our support team by creating a support ticket:

http://support.fabric.microsoft.com/

Hi @Muhiddin thank for submitting the idea.

Can you please clarify if you are looking for every user/ data owners/ developers view on their unused items or from Fabric tenant admin perspective. 

Also I wanted to check if you are familiar with the govern tab as part of the 'OneLake Catalog' which currently target data owners and shows information about their data.

Power Query and Dataflows do not emit data formats, but rather data types. The formatting options that you see in Power BI Desktop are pretty specific to the reporting layer of the semantic model, but those formats are not being emitted by Power Query and Power Query is not aware of them either.

Would you mind telling us a bit more about which scenarios you may need specific formats today for Dataflow Gen2 or where Dataflow Gen2 may fall short for the data types that it supports?

Hi!

After adding a new column to your query, what message do you receive when you go through column mapping of your destination? You should be able to see a message through this dialog that tells you about the schema difference and how you can only map to the existing columns in your destination.

The information about the column maping is different from the query itself. The query itself contains the logic for the output, but the column mapping and the destination dialog is the one that contains the logic as to how your query should be loading data to the destination. More information about this process can be found in the article below:

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn  

We currently support Mirroring with Databricks, Microsoft Fabric Mirrored Catalog From Azure Databricks (Preview) - Microsoft Fabric | Microsoft Lea...
Is this what you are after? Or is it something else?

We have SAP Mirroring which is provided by 3rd party vendors, they are listed on this page: Open Mirroring Partner Ecosystem - Microsoft Fabric | Microsoft Learn

SAP is very big and very complex, so was there a specific SAP system , BW / Hana / you were interested in?

Can your requirement be understood as adding the option of EN-GB (for example) in the language setting of Fabric so that the PBI report can follow the setting and adjust the display format of the time and date.

Can you think of make the date/time fomat fixed when creating the report?  For example: 

In Power BI Desktop, convert the date field to a text format using the Format()  DAX function and specify a format such as dd/mm/yyyy

This way, the format is fixed and will not change based on the language settings.