Can we use Azure Machine Learning on a Azure Analysis Services?
Hello, it's my first post ever since i was hired as Data Scientist after graduating this month. Of course, i have no experience in any cloud microsoft techonologies (yet) and ask for forgiveness in advance if I mix concepts incorrectly. Also, i tried to search similar answers in the forum but sadly found nothing. In our business, we deployed an Azure Analysis Services with our data models ( i think it's called datalake). These models are used most of them for Reporting in Power BI. Right now, we would like to explore more deep types of analysis using machine learning techniques in Azure Machine Learning. The basic problem is how do i acces to the information in the tabular models in Azure Analysis Services from Azure Machine learning? Is this new platform (Azure ML) able to do that easily, without any trick? For example, we tried to make some querys (to Azure Analysis Services) from our locals, using python and pyodbc library. This never worked and there's no information (at least i've found) in the internet. The reason to use python to make querys it's for practical reasons. You make the query, and you call still work on the same notebook without downloading anything externaly, then throw X machine learning algorithm to do Classification, Regression... in the data selected in the query to make a Exploratory Data Analysis. So our idea, would be to replace this locals machines for something in the cloud which i hope have a direct implementation to work with that and also better hardware. Am i wrong, right...? Do you have any suggestion of how we should do things? Please, correct me! Thank you for your answer!