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
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