Forum Discussion
Date acting like text in Excel
I have a field (termination date) that is set to date in power query. It is set to date in desktop. When the user's use Power BI as a data source in excel, it's behaving like text. I'm at a loss....
I've also noticed that if I use "export data" to connect, it comes through as a date. This is only occuring on the OLAP Cube.