Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have spent many days on this now and I have not gotten any closer.
I have a SQL Server (SSAS) Multi-dimensional cube using a LIVE CONNECTION to SSAS and it is not bringing back the correct datatypes. For my Date Time Fields, they are TEXT. Unfortunately, since we are using the SSAS LIVE CONNECTION, i DO NOT have any abilities to modify the field properties, I can not make new fields in Power BI because I have no abillities to create columns or measures, because I have no DAX functionality with the Multi-dimensional cube with live connection
In the Visual Studios for the MultiDimensional Cube you can see the field is Date
In the Power BI the field is a text. The field is greyed out because it is an SSAS Live Connection and I do not have the ability to change it. It tells me i need to change it in the cube setup.
Any help would be greatly appreciated
Solved! Go to Solution.
The answer actually turned out to be quite simple. I needed to change the sort by to Key, and then change the dataformat to yyyy-MM-dd
The answer actually turned out to be quite simple. I needed to change the sort by to Key, and then change the dataformat to yyyy-MM-dd
The video here on using SSAS Multidimensional as a source for Power BI is a few years old but still relevant:
The section beginning at 39:30 on the ValueColumn property is what you should look at - it shows how you can make Power BI recognise dates as dates.
Chris