Forum Discussion
Loading OLAP Date column as text in Power BI Desktop
Super UserNuvAnast , where you have changed the data type.
Check if this is possible in case of a cube, Open power query, Right on the table and open advance editor and if see column list, try to change the data type
refer this video for steps : https://www.youtube.com/watch?v=meUxcbwujl8&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=10
Hi Amitchandak,
Thank you for your answer.
I can't add the step "Changed Type". This step disabled the "View native query options". I need to changed ometing in cube or Power BI desktop settings....
- amitchandak
NuvAnast , Usually for sources like excel, we have a list of columns with data type in the advance editor, I was thinking if you are able to change it there and see if that works. I am not having any cube handy to test that.