User Profile
lance_6
Helper II
Joined 5 years ago
User Widgets
Contributions
URL Parameters for embedding with iframe
I'm working on embedding some reports in an internal tool we use using iframes. I know of a few URL parameters availible for this, but are there more? Obviously some of these are required parameters. appId autoAuth ctid navContentPaneEnabled1.7KViews0likes1CommentRe: Decompress Brotli Data
This is the same thing I found. Looks like although they have the `Compression.Brotli` function, they don't have it implemented and only accept the two options v-yingjl mentioned. Compression.GZip and Compression.Deflate I'm not sure why they would have the functions and not allow for them to be used. Very frustrating, Microsoft being Microsoft.2.6KViews0likes0CommentsDecompress Brotli Data
I'm working with an API that delivers payloads compressed using brotli. I've been looking for documentation on decompressing this in the Power Query Editor. Microsoft's documentation on this is non-existent and I can't figure out how to make it work. Here's roughly what I've got right now: let Source = Binary.Decompress( Web.Contents( "https://testURL.net/history/TestBrotli", [Headers=[Authorization=#"myAPIkey"]] ), Compression.Brotli ) in Source Does anyone have experience with this? Any pointers?Solved2.7KViews0likes7CommentsRe: 4 weeks moving average for Month-Week combination?
I would do something like this in the PQ Editor: #"Inserted Text After Delimiter" = Table.AddColumn(Source, "WeekNo", each Text.AfterDelimiter([Column1], "-W"), type text), #"Removed Duplicates" = Table.Distinct(#"Inserted Text After Delimiter", {"WeekNo"}), #"Inserted Text Before Delimiter" = Table.AddColumn(#"Removed Duplicates", "Text Before Delimiter", each Text.BeforeDelimiter([Column1], "-W"), type text) So you create a custome column based on the week. Remove the duplicate weeks (based on your data it looks like it defaults the sort to week month, you may want to make sure it does or it won't remove the correct weeks). You can then create a measure to get your average pretty easily based on the month.2.5KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.