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

[deep_pr97]

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?

[FabianSchut · Accepted solution]

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

[uselessai_in]

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-bf74fa...

2. https://uselessai.in/microsoft-fabric-interesting-and-hidden-deployment-observations-important-bug-f...

3. https://uselessai.in/microsoft-fabric-stored-procedure-not-reflecting-warehouse-connection-change-in...

4. https://uselessai.in/microsoft-fabric-warehouse-deployment-issue-s-and-potential-solution-s-9ad36041...

[v-shex-msft]

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

[DataBard · Accepted solution]

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.

[FabianSchut · Accepted solution]

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