The following Power Query (M) script demonstrates how to extract a list of dates from a table, convert them into a formatted string, and use them dynamically in an API request: Step-by-Step Guide Explanation: Application in get.myhistory This approach can be used within get.myhistory to dynamically retrieve historical records by supplying a list of relevant … Read more
Overview The Splash View is a flexible data exploration tool in myBMT, providing interactive access to various structured data formats, including: This tool allows users to explore data visually and programmatically, ensuring seamless interaction across multiple file formats. 1️⃣ Availability Where can I find the Splash View? 🚿 Wherever you see the shower icon in … Read more
Microsoft Fabric is designed to integrate multiple analytics workloads, including data engineering, data science, and business intelligence, within a unified platform. While our current Medallion structure already has a logical progression of data refinement (Bronze → Silver → Gold), there are key differences in architecture, tooling, and approach that we might consider while emulating a … Read more
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
MVC, which stands for Model-View-Controller, is a design pattern used in software engineering, particularly in web and application development. It divides an application into three interconnected components, which separates internal data logic from the user interface, allowing for more manageable and scalable code. 1. Model: 2. View: 3. Controller: Workflow Example: Benefits of MVC:
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.
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
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
Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Impact of Expiry: The SAS token will expire on the se date in the URL (e.g., se=2024-10-22T18:23:02Z). If your SAS token expires before renewal: To prevent disruptions, ensure you renew your token … Read more
A SAS (Shared Access Signature) URL provides secure delegated access to resources in an Azure Storage account. The SAS URL you’ve shared grants specific permissions (like read, write, or delete) over a defined period. Here’s a guide on how to use it: Key Components of the SAS URL: Security Reminder Keep your SAS URL secure! … Read more