Forum Discussion
Publishing Azure Analysis Services based reports using the author's credentials
Tx_jeremy,
I suspect that you are using "Connect Live" mode in Power BI Desktop to connect to Azure Analysis Services database, right? If so, there is no option to provide credentials at the Power BI server level. And Power BI only establish connection to the data source in this case, data is not imported into Power BI. You would need to provide users DB level premission for them to view the shared report.
However, if you use "Import" mode in Power BI Desktop to connect to the DB and create report, end users will not require permission on DB level to view shared report.
Regards,
Lydia
Tx_jeremy,
I suspect that you are using "Connect Live" mode in Power BI Desktop to connect to Azure Analysis Services database, right? If so, there is no option to provide credentials at the Power BI server level. And Power BI only establish connection to the data source in this case, data is not imported into Power BI. You would need to provide users DB level premission for them to view the shared report.
However, if you use "Import" mode in Power BI Desktop to connect to the DB and create report, end users will not require permission on DB level to view shared report.
Regards,
Lydia
Thank You, Lydia!
I knew that it had to be something obvious. The "Import" experience is very different but everything makes sense for published content. Live Query is effectively an "authoring" experience and with that mindset I can deliver the reports that I need.
