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

I can't edit Queries in this file.... It's because is a Dataset on Power BI service or it's because is a Excel File in sharepoint?

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

    Looks like you are connected live to PBI Dataset. So there is nothing much you can do, unless you can import the Power BI file with the dataset. If someoneelse developed the Dataset, talk to the person and get the Data type of date changed.

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Nope, Date are the only field that can't be changed in Formatting menu.... :/