Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
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.
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!
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |