Hello, everyone our company is looking to make the change from IBM Cognos to Power BI. Power BI just seems to have far superior visualizations and user friendliness when it comes to its dashboarding and reporting environment.
However one thing that we do love about IBM Cognos is its simplicity and flexibility when it comes to queries. We simply have our Business view from our Cognos Framework Manager Database views published to Cognos so we can create explicit queries for each report without the user changing anything in the underlying data source.
What we want to do is have that great flexibility of queries still when it comes to writing our reports and obtaining data. We want our data analysts to be able to create calculated columns, join and union separate queries together to make a new query.
However we don't necessarily want them to change the underlying data modeling of our data. I simply want them to open PowerBI Desktop, choose our datasource and be able to have the full functionality of PowerBI by creating columns, filtering specific rows, creating calculated tables or specific queries for their report, but not worry about the relationships.
I've been doing some research into these possibilities and seem to be a little bit stuck on how this could work. I thought perhaps datasets could work? But I found out when using a dataset you can't create a custom column, you can't open Power Query, etc.
Does anyone know how we could achieve this? Or should I simply be having our analysts connect to our CloudDb2 data source for every report and making their own custom columns and merges?
