Solved: Power BI interoperability

EmilianoB · ‎04-27-2020

Hi all, I am a newby of PowerBI solutions and I am digging and performing some research to understand if PowerBI is what I am loking for to fulfill my requirements.

I am currently responsible for an application which has a lot of hystorical data. Such data might be useful for some user to make and drive important decision. So I would like to present such data using a BI tool, like Power BI.

As far as I know PowerBI can easily access my data, create tiles and dashboard via Power BI Desktop and present updated view when data changes. My doubts are about the interoperability between the two systems: "My Application" and "PowerBi". In a certain way the data displayed in the Tiles should be "contextualized" given the user input from my application. Something like "I click on a grid in my application (so I have the context) and the Power BI tiles should be populated accordingly".

Expecially what I need to know is:

is it possible to "connect" such systems? Simple example... suppose I have a Power BI tile showing the revenue of my sells split by car manufactures (Audi, Bmw, Mercedes,...). My goal is: if I select in my application a car manufacture like Audi, is it possible to display in my previous tile just the "Audi" data?
The application i develop can be run by different users: one local instance one user on one pc. So, in the example above, one user might want to see Audi data, another one Bmw data, the third one Mercedes one. Is it feasible something like that, maybe running more instance of the PowerBI display?

I really try to figure out the questions for the above points, but I wasn't able to find out proper answers.

Thanks a lot for your attention,

Emiliano B.