We are using Power BI + Power BI Gateway with a live connection to tabular Analysis Server on premise.
That works fine.
However those Power BI users must be autorised on the tabular datamart to use the live connection.
Is it possible to not autorise them ? Only autorise them for the dashboard and not for the underlaying datamart.
I have specified a dedicated on permise user in the gateway. The dashboard should be using that user to query the data. Same as when he is importing or refreshing data.
I am thinking of renaming the pbix file to a zip file, unpack it, edit the connection file and add some properties like effective username to the string. Connection properties to Analysis Services are specified here :