Forum Discussion
Date behavior in PBI Service Dataset
Hi, im new using PBI. I created a simple excel file with a date column (monthly based since 2011), and a couple columns more with some info. The file was saved in Sharepoint site, and imported...
I own the dataset (is in PowerBI service) and I own the Excel file connected with the dataset.
I found the solution, import directly from Excel in Sharepoint to PBI Desktop without using PBI Service Dataset import, and edit the queries.
That's odd, not sure why.
See if you can change the data type without having to go into Power Query.
1. Click on the "Date" field
2. Go to your top ribbon and go to Modeling > Data Type
3. Change Data Type to Date
Nope, Date are the only field that can't be changed in Formatting menu.... :/