Migrating from Qlik to Power BI Reports

[NimaiAhluwalia]

Hey Guys,

I will be working soon on the migration project from Qlik to Power BI for 250 reports.

Just had some general questions

1. Do we have a tool to migrate or do we need to build from scratch in Power BI?

2. Are there any pre-requisites we need to take care of while the process is going?

3. Any inputs from your experience or any documentation will be helpful!

Thanks

@amitchandak 

[selimovd · Accepted solution]

Hey @NimaiAhluwalia ,

Qlik has a totally different approach than Power BI. I'm afraid there is no tool that will help you to migrate reports.

If you're lucky you did the data preparation in the data source and connect with Qlik to real Fact- and Dimensional Tables. If you did the data preparation within Qlik, then you have to analyze what it's doing and try to rebuild that either in the data source or in Power BI.

So concerning your questions:

1.  As far as I know there is no tool. But I found that one here, check if that would help you:

Qlik to Power BI Migration: 4-Wk Implementation – Microsoft AppSource

2. You have to migrate and at one point you will do the switch from Qlik to Power BI if that was the question.

3. You really have to go through every report and rebuild it manually in Power BI.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Bharathi_99]

Hi,

Hi Amit,
Can you help me to convert below qlik to power bi dax

(Count(DISTINCT if(WildMatch(AGGR(distinct CONCAT(distinct [Group ],','),Progress,Grade,ID),'First'),ID))/Count(DISTINCT{<[Group] = {'First,'NotNotFirst'}>}ID),0)

It will be helpful for me

Thanks in advance