User Profile
agranaas
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Interactive CU usage when connecting SSMS/VS Code to Fabric Database
Hello! I'm testing out the database in Fabric and I'm really surprised of the CU usage, it's eating up all available resources. It's an F2 license. When I'm connected to the database with SSMS or VS Code, the CU usage goes to 80-100%, and when I close the connection the usage drops to normal levels. I'm not doing anything (querying, inserting etc.), it's just an active connection to the database in one of the tools (VS Code or SSMS). Is this expected behavior? The warehouse does not behave in this way, I see no spikes in CU when connected with VS Code/SSMS all day long.Dataflow date format is different in Power BI and Power Apps
Hi, The date format in dataflows is behaving differend in Power BI Dataflows and Power Apps Dataflows, and it does not seem to bother at all about the locale set in the transformation. The input for these two queries are yyyymmdd: In Power BI Dataflow this is the result - dates are formatted as mm/dd/yyyy In Powerapps Dataflow the dates are formatted as dd/mm/yyyy: None of the transformations seems to bother about the "Change column type with locale" "nb-NO" which should have displayed the dates as 31.12.2022 and 01.01.2023. Im using the same browser in both cases here. OS language is UK English. Browser language is set to UK English. Power Query Project options are both set to use locale "Norwegian Bokmål (Norway)" Please fix this Microsoft! This is really annoying. Power Query script if you want to give it a try.. let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMjI0MjZUitUBc4wNDA2AnFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [dateint = _t]), #"Changed column type with locale" = Table.TransformColumnTypes(Source, {{"dateint", type date}}, "nb-NO") in #"Changed column type with locale"
