Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |