Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I'm currently looking at PowerBI to replace our aging and expensive Crystal Reports Server. I'm struggling a little with what we want to achieve so anyone can point us in the right direction that would be wonderful (or even give ideas of what we could change?).
The scenario:
The current setup:
What we want to acheive with BI:
From what I understand DirectQuery allows us to constantly request new data without importing it into the report. What I can't figure out is if this is going to allow us to do everything we need to achieve.
Thank in advance!
In theory you sould be able to accomplish your scenario in Power BI using Power BI Embedded along with dynamic RLS. The multiple databases and stored procedure introduces a bit of a wrinkle though.
Hi Greg,
Thanks for the response, really appreciate it.
Regarding the multiple database/sproc issue, this is to overcome limitations in Crystal. We could change it to query the data directly and even merge to a single DB if needed.
Am I thinking correctly, that using Row Level Security would mean querying more data than I need in order to render the report? There would potentially be millions of records if all users were taken into consideration. I was thinking if UserID is passed (somehow) then the select query would only return records for that user? Again, purely theoretical.
Thanks.
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |