Skip to main content
Microsoft Idea

Power BI

Needs Votes

provide JavaScript API hooks for PowerBI reports (on premise SSRS)

Vote (1) Share
Steve Powel's profile image

Steve Powel on 25 Jul 2017 22:17:59

In particular I'm interested in filtering data based on a users position in an organisation hierarchy. So passing in either the userID or organisation unit ID and filtering the data in the dashboard to show appropriate data. HR info like planned leave, resource availability etc.

We are building a "dashboard" using an ajax angular js framework that shows panels with data sourced from various applications.

This includes some charts on HR information and also time/project logging information.

So being able to "filter" these charts by pushing params in is useful.

Most users will also have several different "views" based on the different roles they fulfil on different projects, sometimes this will involve changing the content (page) of a PBIX that is shown
Equally filters and other elements selected in the PBIX could filter the contents of the external panels. Where hours logged are being examined by the delay in data entry, selecting those that have been waiting for approval should call a web based hook to bring up an approval panel in the main page.