Month: April 2020

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/use-power-automate-with-azure-sql-db-to-trigger-a-power-bi-import-dataset-refres/1348614 Power BI Import Datasets are simple to build and highly performant. Power BI literally imports and compresses an optimized cache of reporting data. Most of the time, Power BI architects will schedule their Import Datasets to refresh on a schedule. Sometimes the…

  • This video walks through the process of creating a Power Automate Connection to an Azure SQL Database. Future videos about Power Automate will reference this one to get started with connectivity to Azure SQL DB.

  • Reposted from the Microsoft Healthcare & Life Sciences Blog at this link: https://techcommunity.microsoft.com/blog/healthcareandlifesciencesblog/combine-azure-synapse-and-power-bi-rls-to-analyze-aggregated-data-while-controll/1332312 Let’s start this article off with a simple summary of the use case: Consider the diagram below. A User can see aggregated data for all Specialties, but only two States. When the User drills to detail, they can only see detail data containing PII…