Forum Discussion
Solved
We cannot convert a value of type List to type Table
I'm trying to convert a PBIX into an SSAS Tabular model, and in the PBIX, we have a date dimension built with M that joins to a real table. It works in PBIX file, but as I try to bring that into Tabu...
Because I'm not sure how to use NestedJoin when trying a table built with M with an imported table from SQL, I removed those references from the partition. Then recreated the column with DAX using RELATED. Got the same result. Not sure why Power BI desktop worked differently than SSAS but I have an answer.
Because I'm not sure how to use NestedJoin when trying a table built with M with an imported table from SQL, I removed those references from the partition. Then recreated the column with DAX using RELATED. Got the same result. Not sure why Power BI desktop worked differently than SSAS but I have an answer.