We're investigating a move to Online, but we're getting a bit stuck on reporting. We have some SSRS reports, and are trying to figure out the most equivalent way of doing them in Online. They use SQL that cannot be replicated in FetchXML due to its limitations. We started looking at Power BI, but it looks shockingly more complex (and potentially expensive?) to use as a replacement. It looks like:
1. we'd need Pro licenses to use live data?
2. that a lot of the security isn't automatically implemented the way it is with SSRS when working off the filtered views. I can't even find a way to deal with things that are field level secured even with extra work. It also looks like theoretically people can make their own reports, and if there's an extra step that needs to be done to ensure security, it doesn't seem likely that users will do that. Can this be prevented?
3. It looks like columns cannot be hidden/collapsed?
We haven't even gotten too far into this yet, so there may be more issues/questions we're missing.
Am I misunderstanding this? I'd always seen Power BI positioned as the replacement for SSRS reporting, but these seem to be some major limitations on that, unless I'm just reading things wrong. If anyone's got a really good, definitive guide for handling Dynamics reporting in Power BI, especially regarding security, I'd love to see it. I'm just seeing different bits and pieces so far, nothing that's really comprehensive.
