Built-in SSRS support for Azure AS
It sounds like we need a new data source type in SSRS for Azure Analysis Services. While I think you can use an AAD service account username/password in the connection string, the current EffectiveUserName implementation will fail because it will say EffectiveUserName=DOMAIN\username rather than EffectiveUserName=username@domain.com. I'm hoping that an Azure AS connection type in SSRS could use the UPN for EffectiveUserName or allow some sort of user level UPN override property or user UPN mapping.
Greg Galloway
shared this idea
Thanks for feedback
14 comments
-
Anonymous
commented
We are looking to migrate to Azure but can't if SSRS can't use Azure AS as a datasource. Any new traction on this?
-
Bill Anton
commented
bu-dump
-
Bill Anton
commented
budump?
-
Shrikant
commented
Any timeline for this feature?
-
Vishal
commented
-
Anonymous
commented
Was anybody able to fix this? We tried app registration. Registered a new app used the spn and gave azure as read and write access.
Using app id, tenantid and password we can connect from management studio but when connecting from data source using azure as connection string on report server we get the same error of userid and password expected when interface is not available.
The error seems to be same when you try to process azure as cube from automation account without service principal.
-
pmdci
commented
@Jukka Askvinge I was not able to. What about you? Kiitos.
-
Jukka Askvinge
commented
@pmdci Did you manage to solve your problem with the workaround. I can´t get it to work...
-
pmdci
commented
I tried Greg's workaround that is discussed on his Rent-a-Cube PDF deck but I get an error: Object reference not set to an instance of an object.
Not sure what I am doing wrong here, so I submitted a question in the MSDN forums:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9f8f81cc-60a0-4ec8-8dd1-2e902e48ae51/error-connecting-ssrs-2016-to-azure-as-following-greg-galloways-instruction?forum=sqlreportingservices -
pmdci
commented
Honestly, do we really need to vote in this suggestion to make MSFT work on it? Looks like an obvious priority to me and I am sure I am not alone on this one ;-)
-
Anonymous
commented
i'm also experiencing problems with my Azure AS connection when my report is deployed. Using the work around I can connect SSRS to Azure SSAS in a simple RDL with an embedded datasource but when the report is deployed it experiences connection issues. Any ideas? - I'm using my local instance of SSRS server 2016 for testing purposes
-
Anonymous
commented
I have no trouble connecting to Azure AS in SSRS connection string should be as follows:
Data Source=asazure://southeastasia.asazure.windows.net/myAS;Initial Catalog=ModeName;User ID=AzureADEmail;Password=AzureADPW
-
Vivek
commented
Is there any update on this. Are we able to natively connect to Azure AS from SSRS?
-
Artur Tolstenco
commented
in mean time refer to this workaround https://social.msdn.microsoft.com/Forums/azure/en-US/8794da73-2c52-4d54-89d0-e104d9cabbc0/azure-as-report-with-ssrs