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. 

AkhilAshok's avatar
AkhilAshok
Icon for Solution Sage rankSolution Sage
7 years ago

Just make sure the table is formatted as Date in Power Query Editor. Just right click on the date column in Query Editor, and select Change Type -> Date