@mlessHealthInsuranceMarket wrote:
Hi all,
I was wondering if anyone had any experience with trying to use Qlik Sense Enterprise as the BI endpoint for data housed in the Microsoft Dataverse.
Our BI team has a lot of fiddly little manual workflows that are easily managed by Power Automate, and it would be useful for the endpoint of some of those PA flows to be the Qlik Sense app where the data has to be published. Unfortunately it appears that Qlik is not supported by any of Power Automate's connectors.
Has anyone come up with a solution to this (either for Qlik or another application equally unsupported)? My best idea so far is pushing the data created by the PA flow to an Azure database, and having Qlik connect to that.
Hello,
To integrate Qlik Sense with Microsoft Dataverse using Power Automate, you can push the data to an Azure SQL Database and then connect Qlik Sense to that database. This approach works as follows:
Power Automate Flow:
Trigger the flow when data changes in Dataverse.
Use the Dataverse connector to retrieve data.
Insert or update the data in Azure SQL Database using the Azure SQL Database connector.
Qlik Sense:
Create a data connection in Qlik Sense to the Azure SQL Database.
Load and visualize the data from Azure SQL Database in Qlik Sense.
This method leverages existing connectors and ensures seamless data flow from Dataverse to Qlik Sense.
I hope the information may helps you.
