Forum Discussion
Cognos to Power Bi Migration
oh boy. It is generally not possible to "convert" reports from one system to the other. The reason that so many reporting solutions exist is that hey all have different philosophies and paradigms. For example the storage and association design is very much incompatible between Qlik and PowerBI/SSAS Tabular. Not to mention that the visuals selection is likely different too.
Trying to convert from one system to the other verbatim is also known as "fighting the API" - a fight that you cannot win in the long run.
Having said that, the meta data for Power BI reports is contained in the .pbix / .pbit files and the DMVs. So technically you could create a process that translates your Cognos report meta data into .pbit templates, and that you might then be able to fire up successfully to repull the data etc. But this is a very complicated process, and will likely have unsatisfactory results.
What you should do instead is rank the Cognos reports by usage/importance, and then only recreate the ones that are actually useful.
Hi Rituja ,
What ever lbendlin is 100% true.When I started my career I got a project to migrate cognos reports to reportbuilder(power bi).At that time my manager haven't listened our words and we started recreating those reports in report builder it's a nightmare.At last we wasted 2years developing the reports and the client is no more interested to spend any additional amount due to result changes.So,they decided to stick with cognos ,but they moved the reports to latest version of cognos.
Thanks,
Sai Teja