Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This could be because Power BI doesn't recognize the values in that column as dates.

 

1. Examine the column in detail by going to PowerQuery. To get into PowerQuery, click on the three ellipses next to your table name (in this case "Demanda") and click Edit query.

 

2. Find your column name in the table (in this case "Date"). Click the header to highlight the column and in the top ribbon go to Transform > Data Type and change it to Date. This should cause the icon next to "Date" to look like a tiny calendar.

 

3. In the ribbon, go to File > Close & Apply.

 

And it should start working as intended.