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
Hi Pawel_1990
Thank you for reaching out microsoft fabric community forum.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.