Connect PowerBI to QlikView Data (Connector, ETL, or API)

Hi Anonymous 

I believe that there is no simple solution for the scenario you are living.
Why are you reading the data that was processed in QlikView, why don't you go to the source data and standardize the transformations from QlikView to Power BI? Our company worked many years with Qlik products and now we are focused on Power BI, and we have seamlessly migrated the transformation processes from Qlik to Power BI, if you don't do this, you will always depend on Qlik.
This is a common problem that organizations face when technological changes occur, from our perspective a good DataMart or DataWarehouse should allow you to change Products with little effort. In any case, all the options must be evaluated since they are times and costs very different.

A possible solution for your problem (if the qlik developments were done in 3 layers) would be the following:
The QlikView transformation processes in layer 2 generate QVD files which can also be stored in csv files. You only have to add a line after each Store instruction and the process would be carried out automatically each time the model is reloaded.
STORE "TableName" into "TableName" .csv (txt);
This would allow Power BI to read these files processed by qlik as a source of information and later you would have to perform the minor transformations that are carried out in Qlik layer 3 (presentation).

I hope you find it useful, regards Christian