Forum Discussion
Solved
Slowly Changing Dimension and Direct Query
Hello, I am using direct query in my report. I have currently 4 tables: - Standard Dim_Date - Fact_Table with shape: Account_ID Transaction_ID Transaction_Date Transaction_Value 1 ...
Hello,
Thank you for help rohit1991 - your solution also only work in Import mode. But I found workaround.
In Power Query I wrote manual SQL code. I created foreign key using Account_ID and first date of month in tables:
- Historical_Account _Dim
- Fact_Table (used Transaction Date to get first day of month)
With new key I was ablo to retrieve data. Anonymous Case can be closed
Additionaly, just to clarify, when I switched tables to import mode, everything worked as expected 🙂