Forum Discussion
Seeking Workflow Suggestions
Community ChampionFrom your description I think I would
1) Build a dataflow in Power Bi that executes the stored procedure on a schedule. Never used a connection to oracle but it should be fine.
2) Use dataflows to shape the data into a nice star schema and consume it into a power bi dataset with any measures written. You can do this in power bi desktop or tabular editor and puplish to the service. This becomes your master dataset.
3) You can then use that dataset in both power bi desktop to author reports or if you need the detail of pagniated connect that to the same dataset.
Thanks for getting back to me and providing the suggestion. The stored procedures in question require a parameter(s) be passed. A parameter(s) that the user looking to have the report generated would need to provide. At what point in your approach would the user provide the necessary information?