- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Same DAX Query, works with MS SQL Server as source but not PostgreSQL as source (direct query mode)?
We just migrated from MS SQL Server to Postgre, some visuals in PowerBI work fine after changing Data Sources, but some just bugged out.
For example the same DAX Query below
var y =
CALCULATE(COUNTROWS(FactEmployeeContractSnapshotCDP),
YEAR(FactEmployeeContractSnapshotCDP[EmployeeJoiningDate])=YEAR(x)
&&
MONTH(FactEmployeeContractSnapshotCDP[EmployeeJoiningDate])=MONTH(x)
)
)
return y
Query (1, 1) Function 'DATE' is not allowed as part of calculated column DAX expressions on DirectQuery models.
After some testing, I found out the problem lies in one of these 2 parts (remove either of them works)
USERELATIONSHIP(DimDate[DateKey],FactEmployeeContractSnapshotCDP[JoinningDateKey]),
and
FILTER(FactEmployeeContractSnapshotCDP,
YEAR(FactEmployeeContractSnapshotCDP[EmployeeJoiningDate])=YEAR(x)
&&
MONTH(FactEmployeeContractSnapshotCDP[EmployeeJoiningDate])=MONTH(x)
)
What is going on? There aren't any Date functions here. Also why some simple functions like YEAR and MONTH functions don't even work?
I have done some research on the internet, and people said that this problem is usually because PowerBI DAX doesn't support some kind of functions. BUT IT WORKS WITH MS SQL SERVER AS SOURCE! So why? Is this some kind of SQL-translated problem?
I tried other sources like ClickHouse, and Dremio and got the same error, what the h? Does PowerBI only work with MS SQL Server, or does it work only with MS SQL Server?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI does work with other database. just a limitation of Direct query mode.
you can check the blog here for understanding.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
I hope I anwered your question!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI does work with other database. just a limitation of Direct query mode.
you can check the blog here for understanding.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
I hope I anwered your question!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-04-2024 11:43 PM | |||
05-08-2024 06:41 PM | |||
05-10-2024 10:41 AM | |||
09-05-2024 10:50 AM | |||
03-25-2021 02:49 AM |