topic Re: Which functions are not supported in Fabric that a BI professional must be aware of? in Data Warehouse

Which functions are not supported in Fabric that a BI professional must be aware of?

deep_pr97 — Thu, 19 Dec 2024 14:28:50 GMT

Few functions such as datepart, merge are not supported in fabric. There are few mentioned in the link https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area#limitations. What other functions are not supported?

Re: Which functions are not supported in Fabric that a BI professional must be aware of?

FabianSchut — Thu, 19 Dec 2024 16:32:07 GMT

Hi, what specific functions are you looking for; Fabric as a whole or only the warehouse? If you are talking about Fabric as a whole, you could argue that the CI/CD-process misses some crucial elements and the support of the gateway in Notebooks. However, those are not always used in all scenario's. I would advise you to look at your specific requirements and see if Fabric could fulfill those requirements.

If you particularly mean the warehouses within Fabric, I think you have most of the limitations already in the link you shared, here are a few bullet points more: https://learn.microsoft.com/en-us/fabric/data-warehouse/limitations

Fabric also published the SQL database in preview which has less T-SQL limitations, but that doesn't mean it is a better fit, expecially for BI purposes. You can take a look at the new SQL database here: https://learn.microsoft.com/en-us/fabric/database/sql/overview

Re: Which functions are not supported in Fabric that a BI professional must be aware of?

DataBard — Thu, 19 Dec 2024 18:38:34 GMT

HI deep_pr97,

If you're talking Fabric Warehouse T-SQL limitations, I covered that in a forum response the other day: https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-DW-from-SQL-server/m-p/4334872#M2264

If you are looking outside of Fabric warehouses, please clarify what limitations you are referring to.

Re: Which functions are not supported in Fabric that a BI professional must be aware of?

Anonymous — Fri, 20 Dec 2024 01:03:04 GMT

Hi deep_pr97 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

Regards,

Xiaoxin Sheng

Re: Which functions are not supported in Fabric that a BI professional must be aware of?

uselessai_in — Thu, 09 Jan 2025 12:26:00 GMT

Not exactly as BI but if working on DE tasks, you can check them out.

Find all deployment related issues with their creative solutions here. I tested and implemented all of them. Hope it helps.

link - https://uselessai.in/dont-use-set-variable-activity-in-data-factory-pipeline-microsoft-fabric-bf74fa7d0d34?source=---------0-----------------------

2. https://uselessai.in/microsoft-fabric-interesting-and-hidden-deployment-observations-important-bug-fixes-a87d4c8512db?source=---------1-----------------------

3. https://uselessai.in/microsoft-fabric-stored-procedure-not-reflecting-warehouse-connection-change-in-data-factory-e0dc96e6ce83?source=---------2-----------------------

4. https://uselessai.in/microsoft-fabric-warehouse-deployment-issue-s-and-potential-solution-s-9ad360411f7a?source=---------3-----------------------