Forum Discussion

jsnape's avatar
jsnape
Regular Visitor
8 years ago
Solved

Connection via link://alias fails

:// Hi, firstly a couple of questions:   1. Is the link:// protocol specific to PowerBI or Azure Analysis Services 2. If PowerBI, does that mean a link can point to any valid service e.g. an on pr...
  • jsnape's avatar
    jsnape
    8 years ago

    So I managed to it it working but not by changing any of the URLs etc

     

    The version that didn't work was this:

    link://xxxxxxx.azurewebsites.net/api/cube/test

    This is implemented as an Azure Function App.

     

    Another version that did work is:

    link://xxxxconfig20180828050651.azurewebsites.net/api/values

    This is implemented as an ASP.NET core web app

     

    There is no difference in their implementation as they both use the same C# internally to return the asazure: connection string.

    They both return exactly the same response body.

     

    Only the response headers are slightly different:

     

    cache-control →no-cache
    content-encoding →gzip
    content-length →174
    content-type →text/plain; charset=utf-8
    date →Fri, 31 Aug 2018 08:20:42 GMT
    expires →-1
    pragma →no-cache
    server →Microsoft-IIS/10.0
    vary →Accept-Encoding
    x-powered-by →ASP.NET
     
    and
     
    content-encoding →gzip
    content-type →text/plain; charset=utf-8
    date →Fri, 31 Aug 2018 08:20:47 GMT
    request-context →appId=cid-v1:4226b7bc-9f11-4d6c-a7fe-116613d6e058
    server →Kestrel
    strict-transport-security →max-age=2592000
    transfer-encoding →chunked
    vary →Accept-Encoding
    x-powered-by →ASP.NET
     
    Respectively.
     
    So why does one work and the other doesn't? What specific feature is PowerBI relying on in the second case?

     

    ----

     

    Also the reasons for the additional questions are:

     

    1. The docs are not clear - are you saying all Azure Server names can be aliased like this?

    2. I know this is an alias for Azure Analyis Services, however the link:// works in PowerBI but not Management Studio so I assume this is a PBI feature?

    3. Azure Analysis Servcies.

    4. My screen shots are exactly as per https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-server-alias so hence not posted. - The issue is not how the dialog is filled out but why one implementation doesn't work.

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi jsnape,

 

Seems you don't permission to connect to the Azure Service.

1. It's an alias of Azure Server names.

2. As we can see from the doc, the alias is for the Azure Analysis Services server. What is yours?

3. Which connector did you use in PBI Desktop?

4. How did you input these values in the connector? Can you share some snapshots?

 

Best Regards,

Dale

jsnape's avatar
jsnape
Regular Visitor
8 years ago

So I managed to it it working but not by changing any of the URLs etc

 

The version that didn't work was this:

link://xxxxxxx.azurewebsites.net/api/cube/test

This is implemented as an Azure Function App.

 

Another version that did work is:

link://xxxxconfig20180828050651.azurewebsites.net/api/values

This is implemented as an ASP.NET core web app

 

There is no difference in their implementation as they both use the same C# internally to return the asazure: connection string.

They both return exactly the same response body.

 

Only the response headers are slightly different:

 

cache-control →no-cache
content-encoding →gzip
content-length →174
content-type →text/plain; charset=utf-8
date →Fri, 31 Aug 2018 08:20:42 GMT
expires →-1
pragma →no-cache
server →Microsoft-IIS/10.0
vary →Accept-Encoding
x-powered-by →ASP.NET
 
and
 
content-encoding →gzip
content-type →text/plain; charset=utf-8
date →Fri, 31 Aug 2018 08:20:47 GMT
request-context →appId=cid-v1:4226b7bc-9f11-4d6c-a7fe-116613d6e058
server →Kestrel
strict-transport-security →max-age=2592000
transfer-encoding →chunked
vary →Accept-Encoding
x-powered-by →ASP.NET
 
Respectively.
 
So why does one work and the other doesn't? What specific feature is PowerBI relying on in the second case?

 

----

 

Also the reasons for the additional questions are:

 

1. The docs are not clear - are you saying all Azure Server names can be aliased like this?

2. I know this is an alias for Azure Analyis Services, however the link:// works in PowerBI but not Management Studio so I assume this is a PBI feature?

3. Azure Analysis Servcies.

4. My screen shots are exactly as per https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-server-alias so hence not posted. - The issue is not how the dialog is filled out but why one implementation doesn't work.