Permission on subscription when creating Azure Synapse workspace
I want to create a workspace subscript on Cosmos-bingads-bi, the website prompts me that I do not have the permission. Where should I apply for the permission?
Why can't I connect to analysis services from ssms?
I am getting the below error. Is there something I am missing? Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient) There was an error parsing WS-Trust response from the endpoint. This may occur…
Problema con Backup Automatico en Azure Analysis Services
Buenos días. Hemos desarrollado un sistema de Backups para Azure AS. El caso es que tengo una BBDD Tabular que tarda 1 hora aprox en hacer el backup pero cuando lo programo se queda durante horas y horas ejecutando y no termina. Sabéis si puede deberse a…
Azure Analysis Server becomes unresponsive if tables are getting processed
We have multiple Power BI reports hosted on a server(S9V2) which has multiple databases. We have been noticing that whenever entities are getting processed, the reports are becoming very slow and even the processing of entities take more time than…
Function app not connecting to analysis services server getting Specified method is not supported
I am refreshing a data model in azure analysis services using a azure c# .net6 function app. i am getting Specified method is not supported when trying to connect to analysis services. my connection string looks correct. my server name is correct and…
Azure Analysis Service "There is not enough space on the disk" error during tabular cube process
Hi all, We are using AAS to host a few tabular models; while processing them, randomly, the process fails with the "There is not enough space on the disk" error. As said we're using AAS, not a virtual machine, so we thought that disk space…
Does Microsoft.AnalysisServices.Tabular.NetCore and Analysis services have support for SQL user
I am creating a c# .net 6 azure function app to refresh a data model in azure analysis services. I want to connect to Azure Analysis Services using a connection string using SQL user and password. The docs mention that AAD auth is supported as well as…
Is it possible to open an existing Azure Analysis Services Model in Visual Studio without having to deploy a new model and import data again
Is it possible to open an existing Azure Analysis Services Model in Visual Studio without having to deploy a new model and import data again? The only way I have been able to open an existing AAS model in visual studio is by the following steps: Open…
How to connect to Data bricks catalog database from Azure Analysis services
Hi Friends, There is no native / default connecter from AAS to connect with Azure data bricks catalogue. But is there any work around to achieve this? Please let me know. Thanks in advance.
Which is the best option for data warehouse / Power BI solution?
Hello, I am building a data warehouse in Azure from several external data sources. Data can be imported via pipelines in Data Factory (or Azure Synapse). Data is to be stored in Azure. Reporting through Power BI is required. There seem to be a…
Raw Data Excel to practice Power BI
Hi team, I'm practicing Power Bi service, I downloaded source from your Github, but data already transformed and pivoted. I want raw data to practice measure and data transformation skills. Can you give me the raw data of these sample: Retail Analysis…
Only the role Object ID is displayed in the tabular model's Role list, making it hard to understand the role name. Is there a way to fix this?
The object ID is displayed in SSMS and Visual Studio. Both applications show the object ID instead of the more user-friendly name. It isn't easy to manage roles for a tabular model. Software versions: Microsoft Visual Studio Professional version…
on-premises data gateway issue
My on-premises data gateway is not appearing in Azure when creating a new gateway, even though I selected the same region.
Azure Analysis Services without Models
Hi, I am auditing an Azure account and need assistance with the Azure Analysis service. I have no knowledge of this service, but it seems to involve models. However, the Azure account I am auditing all resources of this service don't have any models.…
Problems opening a tabular model file in different computer where it was created (localhost issues)
Hi! I have been working with analysis services for years (both olap and tabular). In the past, I was able to share the original files of a tabular model with my team members. I found that when someone different from the creator tried to open the file,…
On-Premise data Gateway connection to Azure Analysis Service
Hello All, I am trying to create On-Premise data Gateway connection from Power BI service to Azure Analysis Service (AAS) as my AAS has firewall blockage, but the new connection box only shows Windows authentication option. Is there a way using which…
Catch error when analysis services refresh fail and insert in a sql azure database
How can I catch error when analysis services refresh fail and insert in a sql azure database?
Cannot connect PowerBI to Azure Analysis Service
Until now, everything functioned smoothly. However, today we encountered a problem where both PowerBI Service and Desktop are unable to establish a connection with Azure Analysis Service. The error message indicates an inability to connect to the…
Composite SLAs
All, This is a very generic question. The below link talks about SLAs and how to arrive at Composite SLAs. Is multiplying percentages even the right way to arrive @ a Composite SLA for an application? …
How to allow Private access to Azure Analysis Server?
How to allow private access to Azure Analysis Service?