Step-by-Step Instructions for Parsing a JSON Column in Power BI:
Tips: Example Scenario: If you have a JSON column like this: By following these steps, you’ll be able to effectively parse and use JSON data in Power BI for analysis and reporting.
Power BI
DataMart Token
The data mart token in the myBMT system is a system-generated identifier designed to indicate which Power BI report has requested the data view. Since Power BI cannot send specific environmental identifiers (such as report titles or GUIDs) as part of its payload, this token acts as a substitute, providing a simple yet effective way … Read more
MVC application to Power BI
1. Model (Data Model in Power BI): 2. View (Report/Visualisation in Power BI): 3. Controller (User Interaction in Power BI): Application of MVC to Power BI Workflow: Practical Example in Power BI: Benefits in Power BI: In conclusion, although Power BI doesn’t directly follow the traditional MVC framework, its architecture of separating the data model … Read more
Last Published Date
1. Create a blank query in Power Query Editor like so: 2. Keep “Include in report refresh” unselected. 3. Create a Card visual to show “LastPublishedDate”. 4. Before publishing the report, you need to refresh the data of the “LastPublishedDate” table, not refresh the report.
myBMT.DataView Usage Analysis
DataView Exec get.myView analytics for Prod DataMartsDataView Usage Analysis
My first Power BI
Create Parameters Create two parameters… Use a Token on myBMT The token allows the Datawarehouse to identify with the source of the report, as PowerBI cannot send environment details. (answers on a postcard please, if you know how) So the token is used to give the report a unique identifier myBMT | Token (bmt-dwh-uks-app-my.azurewebsites.net) Navigate … Read more
Wireframe
https://www.figma.com/file/kletVWU6qcByYaT8nQgNjA/Pinstone-Designs?node-id=28%3A2&t=w4RvyzKMdtaWXCGf-1