Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Renewing the SAS Token Install Azure Storage Explorer Connect to Azure Storage A SAS (Shared Access Signature) URL provides secure, delegated access to resources in an Azure Storage account. The SAS URL … Read more
1) What is API API stands for Application Programming Interface. That means it is an interface between two applications/computers that enables them to communicate with each other through some program. You can imagine the API as a postal pigeon delivering your request to the other side and receiving what you (hopefully) expect. In order for the … Read more
Purpose Designed to display the output from the SharePoint List Change Request The myHistory version of the request is designed to evaluate the effectiveness of the change management process. Use Case Owner: Simon WillmoreTypical Use Case: Change Management Dashboard presents key metrics such as the number of open and closed change requestsStyle: Fact Dashboards Utilising … Read more
Purpose: Transfer SharePoint List data through azure blob storage and into the DataWarehouse Requires: Prerequisites: Process Steps: 4. Data Pipeline 5. Create pipeline parameters. Create two pipeline parameters. 5. Activities Tab 6. Look up Activity Click on the Lookup activity and go to settings, from there if not already set up create a new connection … Read more
Purpose: Transfer SharePoint list the Database environment for DataWarehouse Requires: Process Steps: 4. DataFlow Gen2 5. Power Query Window 6. Get Data 7. More… 8. SharepPoint Online List (NOT Sharepoint List) 9. Enter URL 10. Set Implementation to [2.0] 11. [Next] 12. Choose your list 13. [Create] 14 . Rename Dataflow 15. Select [Cog] on … Read more
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.
DataView Exec get.myView analytics for Prod DataMartsDataView Usage Analysis
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
Strive to make data accessible to everyone in the organisation, regardless of technical expertise. Implement self-service analytics tools, intuitive dashboards, and comprehensive data documentation to empower all stakeholders to make data-driven decisions.