Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to store and track the huge and frequently changing structure of Power BI Dataset (not data) using Git.
Right now it's a text or .MD formatted document where all Power Query queries (manually copy-pasted one by one) are stored. All measures also are imported using DAX Studio and written at the end.
Briefly, it looks like this:
* Custom Functions * ExtractJsonFileContent let Source = (fileContent) => let Source = Json.Document(fileContent) in Source in Source * Countries let Source = Json.Document(DS{[Name="lookups"]}[Content]{[Name="Countries.json"]}[Content],65001), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), --- #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Country", Order.Ascending}}), #"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "heapCountryId", 1, 1, Int64.Type) in #"Added Index" DEFINE ---- MODEL MEASURES BEGIN ---- MEASURE 'Some Table'[Fail Rate_Int] = DIVIDE( [Total Failed Tickets_Int], [Total Created Tickets_Int] ) MEASURE 'Some Table'[Success Rate] = 1 - [Fail Rate_Int] ---- MODEL MEASURES END ----
Maybe there is a more effective way to store these structures?
And one more question: How to store the relations between tables and measures?
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |