Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a problem.
I have powerBI report based on Azure Analysis Services and it's published on the web.
People who can't access to AS can't access to my report too, although they are in powerBI workspace.
Thanks
Michał K
HI @mkowalkowski94,
>>People who can't access to AS can't access to my report too, although they are in powerBI workspace.
Do you means the on-premise AS datasource?
If this is a case, current 'publish to web' feature seems not work on-premise AS datasource.
Publish to web is supported for the vast majority of data sources and reports in the Power BI service, however, the following are not currently supported or available with Publish to web:
Regards,
Xiaoxin Sheng
Thanks. Do you know any workaroud?
Hi @mkowalkowski94,
Perhaps you can try to submit an idea for this requirement.(I don't think it is possible, AS source requires effectiveusername, which public access users can't provide)
EffectiveUserName
Use when an end user identity must be impersonated on the server. Specify the account in a domain\user format. To use this property, the caller must have administrative permissions in Analysis Services. For more information about using this property in an Excel workbook from SharePoint, see Use Analysis Services EffectiveUserName in SharePoint Server 2013. For an illustration of how this property is used with Reporting Services, see Using EffectiveUserName To Impersonate in SSAS.
EffectiveUserName is used in a Power Pivot for SharePoint installation to capture usage information. The user identity is provided to the server so that events or errors that include user identity can be recorded in the log files. In the case of Power Pivot, it is not used for authorization purposes.
Guy in a Cube - How authentication works with Analysis Services live connections
Regards,
Xiaoxin Sheng
Ok, but now I have connect to AS in Azure cloud.
Connection isn't a problem, but permission (for my coworkers) it's a problem.
@mkowalkowski94 As with every "Publish to Web" post I comment on, I will re-iterate that using that method is not secure and you are exposing your data publically. That being said, I would imagine that you need to see what account is being passed to AAD/AAS as the users themselves won't be passed via the Publish to Web report you embedded. There is no authentication via that method and a generic user is most likely being passed that you would have to add to the roles in AAS. I'm partially guessing here as I've never used Publish to Web in this way.