User Profile
duardo08
Advocate I
Joined 4 years ago
User Widgets
Contributions
Filter a period in a column of dates with duplicate dates
Hello! I'm trying to filter a period on a column of dates but I get an error saying: "MdxScript(Model) (7,43) Calculation error in measure 'Aux'[count_last_month]: A date column containing duplicate dates was specified in the 'DATESBETWEEN' function call. This is not supported." I'm trying something like this: COUNTROWS(DATESBETWEEN(Table[Date],DATE(2023,1,1),DATE(2023,2,1))) I get the same error if I try with DATESINPERIOD. I'm using Direct Query, I can't create auxiliary columns because it will cost a lot to load. Can anybody help me? Thank you for your attention.Solved2.1KViews0likes2CommentsPower BI connection with AWS RDS PostgresSQL or DBeaver
Hi, I'm trying to connect PBI Desktop with an AWS RDS database, but I'm not getting it, I get a credential error. My company's infrastructure team does not allow me to install the PostgreSQL ODBC driver on my machine to make the connection, and also said that the database does not have the ability to access via ODBC. I can connect to this database through DBeaver, but I cannot collect data from it. I've also tried disabling credential checking, but it still didn't work. Is there any way I can connect to this AWS RDS Postgres directly without installing other programs/drivers or through DBeaver? Thanks for the attention!Solved3KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.