Support formation Rapports Power BI

Share

Explore

Support formation Rapports Power BI

Support formation Rapports Power BI

1 | Se connecter aux données

Récupérer le contenu d'un fichier Zip

Créer une requête vide

Accueil > Éditeur avancé

Supprimer le code déjà présent et coller le code suivant :

(ZIPFile) =>

let

Header = BinaryFormat.Record([

MiscHeader = BinaryFormat.Binary(14),

BinarySize = BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger32, ByteOrder.LittleEndian),

FileSize = BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger32, ByteOrder.LittleEndian),

FileNameLen= BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16, ByteOrder.LittleEndian),

ExtrasLen = BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger16, ByteOrder.LittleEndian)

]),

HeaderChoice = BinaryFormat.Choice(

BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger32, ByteOrder.LittleEndian),

each if _ <> 67324752 // not the IsValid number? then return a dummy formatter

then BinaryFormat.Record([IsValid = false, Filename=null, Content=null])

else BinaryFormat.Choice(

BinaryFormat.Binary(26), // Header payload - 14+4+4+2+2

each BinaryFormat.Record([

IsValid = true,

Filename = BinaryFormat.Text(Header(_)[FileNameLen]),

Extras = BinaryFormat.Text(Header(_)[ExtrasLen]),

Content = BinaryFormat.Transform(

BinaryFormat.Binary(Header(_)[BinarySize]),

(x) => try Binary.Buffer(Binary.Decompress(x, Compression.Deflate)) otherwise null

)

]),

type binary // enable streaming

)

),

ZipFormat = BinaryFormat.List(HeaderChoice, each _[IsValid] = true),

Entries = List.Transform(

List.RemoveLastN( ZipFormat(ZIPFile), 1),

(e) => [FileName = e[Filename], Content = e[Content] ]

)

in

Table.FromRecords(Entries)

Source :

https://www.sqlbi.com/tools/vertipaq-analyzer/⁠

⁠

Share

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.