Forum Discussion

AverageAsker's avatar
AverageAsker
Icon for Helper I rankHelper I
10 years ago

Cannot save a query for live connection

I am building report based on Live data from my SQL Server's table, I imported a table which contains DateTimeOffset column and then added (in Power BI Desktop) a custom column by using this query: ...
Need Help
pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

AverageAsker I haven't tried it, so I can't tell for sure. But you can try adding a calculation in PowerQuery, or cast the type to DateTime (I know in SQL casting to datetime usual translates to local time)

  • AverageAsker's avatar
    AverageAsker
    Icon for Helper I rankHelper I
    10 years ago

    If a calculation in PowerQuery involes Custom Column, then, it doeesn't work as explained above. If you didn't mean Custom Column - can you provide more specifics?

     

    I ended up solving my problem by making all the transformations in SQL.