Forum Discussion

PowerrrBrrr's avatar
PowerrrBrrr
Icon for Helper III rankHelper III
4 years ago
Solved

What's the alternative to use with Direct Query?

So I have table with [TimeStamp] in it and I have created a custom column with below formulae =DateTimeZone.RemoveZone([TimeStamp])+#duration(0,3,0,0) , but this custom column was allowed in Im...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    PowerrrBrrr 

    Of course you can do that in dax, you may create the measure in Direct Query mode.

     

    Measure = MAX([DateTime])+TIME(3,0,0)

     

    Best Regards
    Paul

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PowerrrBrrr 

I am afraid you can only switch the connect mode to import, this is a limitation of direct query. Is there any reason that you don't want to use import mode?

 

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs

"To remedy the error, either delete the problematic step in Power Query Editor, or import the data instead of using DirectQuery."

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

PowerrrBrrr's avatar
PowerrrBrrr
Icon for Helper III rankHelper III
4 years ago

its just we cant use import here, due to some limitation on data frequently changing. isnt there a way we can increase the hours in my timestamp field by 3 or 4 hours. thats all i need to change the time zone