Dear Product Group,   Why is the very common function not supported in the Fabric Warehouse?   It is supported on all other flavor of SQL Server.  Yes, I can query the sys.objects table to get the id, but a shortcut function reduces my total amount of code.   Sincerely   John Miner Data Platform MVP         ... View more

Hi Product Team,   In SQL Server, the fastest way to get a row count from a set of tables is shown below.  Unfortunately, the wrong aswer is coming back, zero records.     If we look use a SELECT statement, we get the correct row count.   The statement is supported in TSQL for MS Fabric Warehouse but does not work correctly.   Sincerely   John Miner Data Platform MVP   ... View more

What if there was a Copilot button on every error message, from creating a connection to validating a job? If creating a connection failed, and I got an error message with a copilot entry, I could click on that and understand more details about the error and what I should do next. ... View more

A Fabric lakehouse table is displaying an empty result (rows with no data in any column), even though the SQL script used to populate it hasn't changed. The data appears correctly in the Power Query editor, but after publishing or refreshing the dataset, the table shows no data.  ... View more

(a) In a Notebook, how can we execute a SQL statement? In Databricks notebook, we can change it to be able to execute SQL statement with %sql, but it is not possible in Fabric. spark.sql("SELECT month, round(SUM (rainfall),2) as MonthlyRainfall FROM ParquetRainfallTable WHERE location == 'Clementi Road' AND year == 2023 GROUP BY month, month_numeric ORDER BY month_numeric").show() (b) In the above SQL statement, it displays a table of values for month and MonthlyRainfall. However in Databricks, it can display a barplot easily in a Notebook. Can Microsoft consider this as an enhancement? it would be very useful, not only for barplots, but for other visualization like map too. Thanks. ... View more

As per this post mongo connections are not able to support readreference or params in the connection string: https://community.fabric.microsoft.com/t5/Data-Pipeline/MongoDB-Atlas-for-Pipeline-Connection-Options-in-URL/m-p/4263144#M6124 This is a huge issue for us as we do not want to degrade performance of the mongo database while doing our reads.  ... View more

Fabric Feedback   SQL Endpoint / Lakehouse Why would the functionality of SQL Analytics Endpoint of a Lakehouse be so dependent on relationships made in the default sematic model? Ideally should be decoupled Issues with default sematic model will disrupt users trying to pull data from PowerBI or externally Default sematic model shouldn’t be touched at all? Why does functionality exist PBI experts told us to ever use default semantic model -- leads to confusion on our end SQL endpoint data is not refreshing on its own, we should not have to run scripts to manually refresh the data, it should refresh on its own Certain features are not available without notice that the features are in preview/testing Ie. AT TIME ZONE not being available anymore Creating relationships between tables in the sematic model take a while or errors are given which leads to multiple attempts being made   Pipelines Deployment pipeline permissions should be separate from workspace permissions, no reason someone with test access permissions should be able to trigger a push to prod Trigger job for Data Warehouse via data pipelines should make it mor useable or us, plus beig able to interact with them somehow with a spark/python workflow,  the keys and classic SQL constraints you can put on a table in the Data warehouse are very useful for dim data, but there is no straightforward way to ingest CSVs from source control that manage our slow moving dim data and update tables without using some sort of python library   Permissions Access to an individual entity level is important If a user is granted contributor access to a workspace shouldn't mean they should edit all notebooks in it Misc/Minor VS code and Fabric experience is not viable Development in browser is not ideal Connection to the Spark pool always requires internet connection, but unexpected browser refreshes lead to lost work Data pipeline job history is basically unusable for any performance monitoring. Ideal to have bar chat showing duration of each job Dark mode would be nice  ... View more

green construction/ green material supplier/ green logistics / esg finance/ sustainability/ SDG/ looking buyer supplier/ fintech patnership. ... View more

Since the Azure Synapse Influencer program appeared to be so popular, I propose to have the same program in-place for Microsoft Fabric. ... View more

Good Day - I am not sure if this is the correct forum to ask this question. I woke up this morning to go to the Fabric Community web page and found out I was banned. I am trying to get some idea as to what I did or behavior I displayed that have me banned. The only thing I did was signed up for the challenge. This is my first time joining the community and would like to participate in the challenge. Please provide details as to how to correct this but it will not allow me to sign in using my outlook email address. Down below is my information: Tracy Seabrooks tseabrooks01@outlook.com Thank you ... View more

Hello, I would love the option to receive a notification whenever a Fabric Idea gets promoted to the Microsoft Fabric release plan documentation, updates on estimated release dates, and when it is released. The link to the documentation could be included on the Fabric Idea once planned, and then a link to the monthly feature release article once delivered. The links could be added next to the Comments/Merged tabs. The reason I think this would be valuable is because the Fabric community can then track the maturity of an idea, and specifically receive updates on estimated timelines to deliver, and then utilize immediately once released. Thank you, Daniel. ... View more

Hi Team, I have started forecasting the SKU utilization for Fabric using the Fabric SKU calculator in the Excel tool. While changing the values for the "Daily DW/LH Processing" category, I noticed it has a significant impact on the SKU selection. However, I am unclear about the exact values that should be entered here. Could you please clarify what "Daily DW/LH Processing" refers to? Does it represent the number of pipelines in ADF, or is it related to the data size processed daily through batch ETL? Looking forward to your guidance on this. ... View more

In the current Welcome to Fabric home pages for each persona there are the "Create a Workspace" activities on the left, and the "Create Items" on the right. this works fine in Data Factory, because there's only a couple of items, but in other personas the "Create Items" section is condensed and requires scrolling. It would be nice if these two banners could be adjusted by dragging the | divider, or if the two banners just took up 50% of the real estate each. ... View more

I'm using Quicken for my contracting business, and I keep getting a "Quicken Window Has Stopped Working" error. This happens frequently and disrupts my work. Has anyone else encountered this issue? Any solutions or tips would be greatly appreciated! Thanks! ... View more

I'm looking to hire my first 1099 contractor and want to ensure everything is set up correctly. What steps do I need to follow to comply with IRS regulations and manage taxes properly? Any tips or resources would be greatly appreciated! ... View more

I'm encountering System Error Code 1722 during software installation. The process halts unexpectedly with this error, and I can't figure out the cause. Has anyone faced this issue before? Any solutions or troubleshooting tips would be greatly appreciated! ... View more

I'm facing Rebuild Error Code 310 while trying to repair data in my contractor software. The process fails each time, and I can't figure out the root cause. Has anyone dealt with this issue before? Any insights or solutions would be greatly appreciated! ... View more

as a member of development team who is responsible for reporting platform we would like to have a central dashboard/app where there would be list of features/services that would be soon deprecated related to Office 365 products or Azure. The reason for this is currently there are many blogs to follow news which is for us currently not possible to track all of them as they many times include information's not related to us as we are interested only in operational stuff so it is hard for us to follow. Recently as an example we had issue with capacity metrics app which was deprecated and we only got information about deprecation once the app suddenly stop refreshing and we searched for root cause. It would be very help full to have central place where we can look for future changes so we can plan in advance instead of hot-fixing the issues. ... View more

Hello, The loyalty redemption standard functionality does not meet the legal requirements in Spain. The Spain legal requirements regarding loyalty points redemption is the following one: when a customer wants to pay with loyalty points, it should reduce the value from the amount without taxes (Base imponible), therefore, acting as a discount. The Dynamics solution allows to pay with loyalty points as a payment method, therefore it acts upon the total amount of the transaction: amount + taxes. In the configuration of the loyalty scheme there is a Redemption type called "Loyalty points discount". This option seems to be disabled as per the documentation available. This option is exactly what we need. Do you intend to reactivate this functionality? Thank you. Best regards, Ainhoa ... View more