The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi there,
I was planning to build a live dashboard that has all the data stored in Azure SQL DB, I was planning to use direct query instead of import so that I would avoid schedule refreshes and avoid load on the database services. Direct Query works fine till I want to modify the UTC to local time. I cannot add a column and use "DateTimeZone.SwitchZone" for converting my dates from UTC to local.
Is there any workaround for conversions? If not should I go back to Import Query mode and perform schedule refreshes?
Solved! Go to Solution.
@Anonymous , when you create a connection there is the connection to give a query. You can use that.
simple addition and subtraction can work in dax and power query. If your timezone do not change with the season then you can simply try to add and subtract time and check
@Anonymous ,the best way is to use a SQL in advance option and do the conversion in SQL.
Is there a way to do it in Power BI? The reason is I am not the owner of the SQL DB and any changes to it might be a long process of approvals and documentation.
@Anonymous , when you create a connection there is the connection to give a query. You can use that.
simple addition and subtraction can work in dax and power query. If your timezone do not change with the season then you can simply try to add and subtract time and check
Yeah, that worked brilliantly, thanks for the quick response 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |