Currently Visual Studio is displaying all the AAS tabular measures as a flat list instead of a folder structure. Although a value can be set to organize them in folders using the display folders, it only applies in PowerBI or Excel. It would be usefull if Visual Studio is also respecting the display folder value, organizing the items in folders rather then a flat list making it easier to navigate them opposed to a long flat list. ... View more

For Reusage of code and doing some extended stuff it could be usefull to call a fabric User data function from a DAX script. For example could this be usefull to call an api to a authentication source for RLS comparision and so on and also for for example reuse the same functionality again as a kind of building block.     ... View more

I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow.   Also, the tooltip also doesn't show the entire cell contents when hovering over a cell.   Please make it possible to see the entire contents of a cell in the SQL Analytics Endpoint user interface. ... View more

As already reported and discussed here: https://community.fabric.microsoft.com/t5/Data-Engineering/Some-methods-in-notebooks-do-not-work-when-executed-from-Data, and based on the feedback from Microsoft support that this is a known issue and that an Idea should be opened for this - I suggest this issue is further analyzed and a fix or workaround is suggested.   Reference support case I opened (and also more people opened the support case with the same issue): 2504161420001430 ... View more

In one of our dev data pipelines, the conenction to a source was unable to be established.  The expected result is for this to stop the job and report the failure.   The Copy action failed, as expected as it did not have access to the source.  Unfortunately, the copy action also continured to run and overwrote data in the sink/destination table with blanks as it could not retrieve data from the source.    Data Pipeline - Copy actions should not be able to continue running after it is unable to establish a connection with the source.   ... View more

Hi , I would like to request if we can add shortcut for sharepoint documents in lakehouse, that would be really great or the connection in the pipeline to read directly from the sahrepoint folder. ... View more

SET QUERY_GOVERNOR_COST_LIMIT feature is available in Fabric SQL Endpoint.  However, the official documentation states that Fabric SQL Endpoint is not supported in the products that support this feature. We want this feature to be added to the official documentation so that it can be used in Fabric SQL Endpoint. SET QUERY_GOVERNOR_COST_LIMIT (Transact-SQL) - SQL Server | Microsoft Learn ... View more

Make it possible to write SparkSQL without having a Default Lakehouse.   With 3- or 4- part naming, i.e. [workspace].[lakehouse].[schema].[table]    there should be no need to attach a Lakehouse in order to use SparkSQL.   Needing to attach a Lakehouse is annoying and adds extra complexity. ... View more

Assume in your data model you have Many-to-One relationship between your 'FactTbl' and 'DimTbl' on the column 'CustomerKey' and the the connection is in DirectQuery mode.   Now assume that bad data is entered in your 'DimTbl' and it has caused that you have a duplicate value in the column 'CustomerKey' of your 'DimTbl'. If you refresh your Power BI, it gets refreshed successfully without any errors.   Now what happens? If you have created visualizations before, you might see some data in your visuals that is too weird which are caused by Many-to-Many Relationship behavior. You go and check your data model to find out the reason and it shows you that the relationship is Many-to-One and it is too frustrating as you cannot find the reason of what you see !   But the same case in Import mode works fine and once you hit the Refresh button in Power BI, it gives you the error: "Column CustomerKey contains a duplicate value and this is not allowed for columns on the one side of a many-to-one relationship or for the columns that are used as the primary key of a table".   The same error is expected in DirectQuery mode as well and it needs to be fixed.   Regards, Loran ... View more

Short and simple request: I would love to be able to 1-click edit my notebooks like I can with downstream pipelines (and Dataflows).             I know I can click the Notebook activity (1), click Settings (2) and click Open (3), but that way I need 3 clicks instead of 1! 🙂 ... View more

df = spark.read.format("jdbc").option("url", jdbc_url).option("dbtable", f"({query}) as tmp").options(**jdbc_conn_properties).load() df.printSchema()   When checking how Azure SQL Database types are read in Fabric using JDBC INT, BIGINT and SMALLINT are transformed into logically sized types. TINYINT is read as an integer by default, which is not efficient in storage use.     ... View more

Visibility into Source Table Metadata Currently, there is no available option to view metadata or properties (such as data source name, original location, or table lineage) for a Shortcut table. Providing this level of visibility is critical for data governance, auditing, and root cause analysis. Especially in environments where multiple shortcuts and data sources are interconnected. This information would be invaluable for both developers and administrators managing enterprise data at scale.   Improved Stability and Reliability of Shortcut Integration We've observed some recurring instability or performance issues when using Shortcuts in production environments. Enhancing the underlying reliability and offering better diagnostics or logging would go a long way in increasing user confidence and adoption of this feature. ... View more

Overtime queries ran on a sql end point in a lake house build up in the my queries folder. They have to be individually deleted which can take a lot of time. There should be a way to delete all or highlight an delete multiple queries  ... View more

Currently the server name for SQLDB (and DW) is a double GUID of {tenant-Id-workspace-id.}database.fabric.microsoft.com   This causes a lot of issues as 1. This is impossible to remember 2. We ahve no way to distinguish test from PRD   We request user frirnedly DNS Names like  Prodata-Sales-DEV.database.fabric.microsoft.com   This would help clearly label an worksapce as DEV or PRD and avoid confusion and make the platform easier to work with., ... View more

To support business users, provide a GUI-based table creation feature that requires no coding. ... View more

In paginated reports, if a business needs to display the same column under two or more different names, this is currently not possible in Fabric. While it is technically possible to pull the same column into the visualization multiple times, renaming one instance automatically renames all duplicates. If Fabric allowed the same column to be displayed under multiple names, it would greatly benefit business users. Currently, to achieve this, we must modify the dataset at the Data Engineering (DE) level, which becomes a tedious process—especially when DE and Data Analytics (DA) are handled by separate teams. ... View more

We would like for you to enable the Scheduling of a Notebook using the REST API in Fabric using a Service Principal. We want to automate our deployment pipeline and this is a critical step towards achieving full cross tenant automation .   Reference:  Create Item Schedule: https://learn.microsoft.com/en-us/rest/api/fabric/core/job-scheduler/create-item-schedule?tabs=HTTP Update Item Schedule: https://learn.microsoft.com/en-us/rest/api/fabric/core/job-scheduler/update-item-schedule?tabs=HTTP     ... View more

Basically, we should be able to edit the final output (data destination) columns directly in the Dataflow Gen2, without needing to go to the Warehouse itself to add the new columns (using T-SQL).   This should be possible to do in the Dataflow user interface both for the Append and Replace options.   The settings in the dataflow outputs should be applied to the destination (Lakehouse, Warehouse) without needing to go into the Warehouse or Lakehouse to add the columns.   This should work regardless of writing to a New or Existing table.    This should just work.   We should be able to choose which columns to write to the destination, and add more columns to an existing table, directly in the Dataflow user interface, without having to go to the Lakehouse or Warehouse to make any changes. ... View more

When creating connections to any database or api or any other source systems, we're not able to access the credentials from Keyvault secrets as similar to Azure Data Factory. Connection to an Azure Keyvault instance also helps in accessing the credentials in an easier and secure way. ... View more