Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |