Fabric – Refresh PBI Dataset using Python API

To invoke Power BI Dataset refresh using Python, use 'requests' library to make HTTP requests to the API. Prerequisites: Library installation ("requests"), if the library is not installed then use 'pip install requests' A valid Power BI Access Token is needed to make the API requests that can be generated via Azure AD Service Principal … Continue reading Fabric – Refresh PBI Dataset using Python API

Data Lake Storage to Synapse Analytics using Managed Service Identity (MSI) – COPY INTO and PolyBase

Why to use MSI? Easy to authenticate any Azure Active Directory supported serviceProvides limited visibility of the credentialsMore secured than SQL authentication and less susceptible to hacking Configuration steps Create a storage account and enable Hierarchical namespace for Data Lake Storage Gen2.Within storage account, create a container for file system .Navigate to Access Control to … Continue reading Data Lake Storage to Synapse Analytics using Managed Service Identity (MSI) – COPY INTO and PolyBase