Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
Use sql server analysis service connect Azure Data lake gen2 error for [500] Could not execute the specified command: Invalid HTTP response! System error: Don't know about such a host。.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 1%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nemo
0
Reputation points
my steps below:
1\create data source:
using 'cdata ado.net provider for azure data lake storage2023 provider' to connect our Azure data lake gen2,and the authentication is SAS
2\create data source views:
when I create data source views ,I can just only see one object,I can't see the tables on Azure data lake,why?
3\I create the view with the only one table.
when I explore data from the table ,it poped up an error :
[500] Could not execute the specified command: Invalid HTTP response! System error: Don't know about such a host
If anyone else has been in this situation?
Azure Data Lake Storage
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
{count} votes
-
PRADEEPCHEEKATLA 90,641 Reputation points Moderator2023-08-04T09:27:54.49+00:00 @Nemo - Thanks for the question and using MS Q&A platform.
It seems like you are encountering an error while trying to connect SQL Server Analysis Service to Azure Data Lake Gen2. The error message you provided indicates that there might be an issue with the host name.
To troubleshoot this issue, you can try the following steps:
Check if the host name is correct. Make sure that you have entered the correct host name for your Azure Data Lake Gen2 account. You can verify the host name by going to the Azure portal and checking the properties of your Data Lake Gen2 account.
Check if the firewall rules are configured correctly. Make sure that the firewall rules for your Data Lake Gen2 account are configured to allow traffic from your SQL Server Analysis Service.
Check if the network connectivity is working. Make sure that there are no network issues that might be preventing your SQL Server Analysis Service from connecting to your Data Lake Gen2 account. You can try pinging the host name to see if there is a response.
If none of these steps resolve the issue, you might want to consider opening a support ticket for further assistance.
-
PRADEEPCHEEKATLA 90,641 Reputation points Moderator
2023-08-07T06:49:44.29+00:00 @Nemo - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer