Forum Discussion

zstutzman's avatar
zstutzman
New Member
10 years ago

Insightly Dates

I really like the bi tools integration, however noticing an issue with dates. Via the API integration they are being passed as text or numbers instead of as "date" data type.
Need Help
brndnr's avatar
brndnr
Regular Visitor
8 years ago
As a potential workaround before they address this issue, can you not transform these columns in Query mode?
Idan_liniad's avatar
Idan_liniad
Frequent Visitor
8 years ago

Hey brndnr,

thanks for your answer, I'm not sure how to do this. can you please elaborate? 

  • brndnr's avatar
    brndnr
    Regular Visitor
    8 years ago

    Download a copy of your report and then open it using the desktop version of Power Bi. Once it's opened, go to Edit Queries, then select the data set that you are referring to. Select one of the columns that isn't in the right format, then select the 'Transform' ribbon at the top of the window. In the 'Any Column' menu, try change the data type to what you feel that column should be (date?). You can also play around with the 'Date & Time Column' at the top.

     

    If this is working as-is, your column should automatically changed to the dates you need. Bear in mind there may be a difference in timezone ortime format, which you can attack in a different way. This may not be the case, just something worthwhile checking. See how you go

    • Idan_liniad's avatar
      Idan_liniad
      Frequent Visitor
      8 years ago

      Hey brndnr,

      thanks for your answer.

       

      I'm not able to download the report as you described.

      please see the next screenshot:


       

       

       

       

       

       

       

       

       

       

       

       

       

       

      I think it's because this dataset is through Power BI app