Forum Discussion

yijichen's avatar
yijichen
Microsoft Employee
11 years ago

Timestamp only have date when directly connect to SQL database through Powerbi.com

Hi PowerBI Team,   When connecting to SQL database directly from pwerbi.com, the visualization will lose the time part from the timestamp. For example, 2015-08-01 14:00 will become 2015-08-01. Is...
Need Help
ashishrj's avatar
ashishrj
Power Participant
11 years ago

yijichen You can set the Data Type in Query Editor as shown below

queryeditor.png

  • yijichen's avatar
    yijichen
    Microsoft Employee
    11 years ago

    Thanks for your feedback ashishrj!

    I agree with you that connecting SQL database through PowerBI desktop or Power Query will not have the probelm I mentioned. However, if we directly connect SQL database through PowerBI.com, this error can't be fixed with the same way.

     

    Refresh frequency is the main reason for why I would like to connect to database directly through powerbi.com. If I do this way, the dashboard can be refreshed every 15-20mins for 24/7. If I connect SQL through PowerBI desktop or Power Query, it can only refresh 8 times a day.

    • ashishrj's avatar
      ashishrj
      Power Participant
      11 years ago

      yijichen Sorry I saw this now that you are directly importing it in online. I suppose there is no option for customization or formatting in Power BI Online.

      You can do so in database itself before importing it in online service

      • yijichen's avatar
        yijichen
        Microsoft Employee
        10 years ago

        I tried that and it is still not working. I guess we need to wait PowerBI team to response this issue.