Publishing Azure Analysis Services based reports using the author's credentials

[Tx_jeremy]

I have a deployed Azure Analysis Database and I have published a report (pbix) from Powe BI desktop.  Everything looks fine in accessing and refreshing the report from my account.  However, whenever I attempt to share a report/dashboard/app created from this dataset with another user, the report failes with the message "couldn't load the model schema" in each frame.

With reports from other data sources, I can see the option to provide credentials at the power bi server level however I cannot see this option for my Azure Analysis Services Database.  The only way that I have found to enable the report consumer is to add them as a reader on the Azure ASDB.  This is not an acceptable solution as it effectively makes them a report author.  There has to be some way to share developed content with another user without giving them db level permissions.  I feel like I must be missing something obvious. 

[Anonymous · Accepted solution]

@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]

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.