๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo

6.9K posts

๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo banner
๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo

๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo

@GilbertQue

#PowerBI #Fabric & Data Consultant. Blogger (https://t.co/9Ukem11iGu) Microsoft MVP

Gold Coast, Australia Se uniรณ Ocak 2009
242 Siguiendo5K Seguidores
๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo retuiteado
Arun Ulag
Arun Ulag@arunulagยท
At #FabCon and our first-ever #SQLCon in Atlanta with 8,000+ customers, partners & community members. ย  Enterprises are moving fast to AI-driven, multi-agent systems. The blocker isnโ€™t models. Itโ€™s data + context. ย  New this week in #MicrosoftFabric: Database Hub โ€ข OneLake updates โ€ข Fabric IQ + integrated planning โ€ข Data agents (GA). Get the details: tinyurl.com/5n6k5fhr
Arun Ulag tweet media
English
9
16
75
22.1K
๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo retuiteado
Marco Russo
Marco Russo@marcorusยท
Use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure. Article + video available! #powerbi #dax sqlbi.com/articles/debugโ€ฆ
Marco Russo tweet media
English
3
7
29
1.5K
๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo retuiteado
Micah Dail
Micah Dail@MicahDailยท
@GilbertQue I'm not talking about refresh info. This really has to do with a TMDL definition change. How would you determine TMDL modification timestamp? Is your cached TMDL definition still matching what's in the service? Can you tell me without pulling the definition in service?
English
1
0
0
29
Micah Dail
Micah Dail@MicahDailยท
Anyone know of a reliable method for tracking the modification time of a deployed semantic model in Power BI / Fabric? I haven't found an API that returns this, and the closest I've gotten to the idea is executing a DAX query (like below, which I hate). The idea here is to cache a model definition, and calculate if the cache should be expired. How do we calculate expiry? EVALUATE VAR _model_modifiedtime = SELECTCOLUMNS ( INFO.MODEL (), [ModifiedTime] ) VAR _annotation_modifiedtime = SELECTCOLUMNS ( FILTER ( INFO.ANNOTATIONS (), [Name] IN { "Lineage", "SampleValues" } ), [ModifiedTime] ) VAR _table_modifiedtime = SELECTCOLUMNS ( INFO.TABLES (), [ModifiedTime] ) VAR _column_modifiedtime = SELECTCOLUMNS ( INFO.COLUMNS (), [ModifiedTime] ) VAR _calcgroup_modifiedtime = SELECTCOLUMNS ( INFO.CALCULATIONGROUPS (), [ModifiedTime] ) VAR _calcitem_modifiedtime = SELECTCOLUMNS ( INFO.CALCULATIONITEMS (), [ModifiedTime] ) VAR _measure_modifiedtime = SELECTCOLUMNS ( INFO.MEASURES (), [ModifiedTime] ) VAR _hierarchy_modifiedtime = SELECTCOLUMNS ( INFO.HIERARCHIES (), [ModifiedTime] ) VAR _hierarchylevel_modifiedtime = SELECTCOLUMNS ( INFO.LEVELS (), [ModifiedTime] ) VAR _all_modifiedtimes = UNION ( _model_modifiedtime, _annotation_modifiedtime, _table_modifiedtime, _column_modifiedtime, _calcgroup_modifiedtime, _calcitem_modifiedtime, _measure_modifiedtime, _hierarchy_modifiedtime, _hierarchylevel_modifiedtime ) VAR result = MAXX ( _all_modifiedtimes, [ModifiedTime] ) RETURN { result }
English
3
1
3
341
๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo retuiteado
Nikola Ilic
Nikola Ilic@DataMozartยท
NEW BLOG POST! In this article, which is adapted from the "Analytics Engineering with #MicrosoftFabric and #powerBI" book, I provide a crash course on the architectures that shape your daily decisions โ€“ from relational databases to event-driven systems. data-mozart.com/why-every-analโ€ฆ
English
0
2
18
816
๐˜Ž๐˜ช๐˜ญ๐˜ฃ๐˜ฆ๐˜ณ๐˜ต #FourMoo retuiteado
Marco Russo
Marco Russo@marcorusยท
The new calendar-based time intelligence functions offer greater flexibility than the classic time intelligence functions in DAX. This article describes the DATEADD parameters for controlling different granularity shifts in Power BI. #dax #powerbi sqlbi.com/articles/underโ€ฆ
Marco Russo tweet media
English
1
9
48
1.8K