PowerBI Embed, App Owns Data, Direct Query

Hi Mario,

              I'm looking into something similar at the moment and so here are few pointers if they are of any use:

1) When you say direct query, have you set up gateway datasource to have direct query option ticked? 

2) If you are using SSO, have you done all that is required on the gateway machine to delegate?

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sso-kerberos-sap-hana 

3) With Direct Query there are 2 cases

     i) do you want the report to be run using one single account - so if userA or userB or userC is opening the report the underlying datasource is hit with a predefined username/password which is set in the datasource of gateway

   ii) do you want the report to be run in the context of userA if userA has opened the report and userB if userB has opened the report and so on? if so you'd have to configure kerberos SSO

Assming you want the most upto date info on your TV screen, you need direct query report and if you have kerberos SSO enabled your credentials will be passed over to the datasource (App will not have access to the datasource) and the report will keep refreshing (assuming you've enabled page refresh every xx mins). Provided all the settings are configured correctly report should refresh.

-Rakesh