Insufficient permissions when I click on Log Analytics or Workbooks
I'm in the Entra Admin Center under Monitoring & health and click on Workbooks I get an error saying "Insufficient permissions" and then showing me this (Subscription-ID cc01... is changed, this is not the one that is shown in the real…
Identifying Unused Tables in AAS Cube Over the Last 30 Days
I have a question regarding identifying unused tables in Azure Analysis Services (AAS). In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used…
Analysis Service not loading big tables fully from SQL Server
We experience a very strange issue when uploading data from our SQL server to our analysis service, which we are hoping to get a bit of sparring on. Briefly explained, the issue is that simple select queries for our largest tables terminate…
Cant create new Analysis Services in D1 or B1 tier in West Europe
I am unable to create new services in D1 or B1 tier in West Europe region. Deployed in S0 West Europe or D1 in UK South went fine. I have also check and we didnt have such thing as quotas/limits for Analysis Services also, so I am not hitting any…
Names of Azure Services in the Azure IP Ranges and Service Tags JSON File
What are the official names used for the following Azure services in the Azure IP Ranges and Service Tags – Public Cloud JSON file? Azure Function (AzFunction) Automation Account Azure Batch Analysis Services You can refer to the JSON file…
Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?
My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…
Inquiry about Exported Log Verification on Power BI Service Workspace Reports
Hello everyone, I am exploring ways to verify the exported logs for reports on the Power BI Service workspace. According to the official documentation, does the event ID 92 “File Save Begin” indicate an export log? Thank you for your assistance! Best…
How to use the format string function in the column properties to do custom formatting
Hello, I have a date_key column with data type whole number and formatted as Text as shown below. I want to apply this same logic to the date_key column in another table for my measure to work. I don't remember how to use the custom formatting and…
Import databricks data using tabular editor
I imported data from databricks to AAS using the Simba ODBC driver but after deploying the model, i can't seem to make the refresh work. I get this error "Failed to save modifications to the server. Error returned: 'Expression in partition…
How do I create an Azure Analysis Services instance?
How do I create an Azure Analysis Services instance?
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?
Can I connect to a databricks table and pull data directly into AAS for our daily data refresh (processing)
I want to connect to databricks tables directly using azure analysis services (AAS) and pull data into our AAS model during our daily model processing.
Azure analysis services Scale out replica cost if I need S8v2 replica for 24hrs a month
Hi All, Can the Azure Analysis services Scale out cube replica be provisioned only at the time of cube processing?
Simplifying data landscape with Synapse
How can I use Synapse to simplify my data landscape for maintenance and cost, assuming the lake is always a constant? I currently have two environments: Lake - Databricks(ETL) - Power BI Lake - ADF - AzureSQL - Analysis Services - Power BI I'm…
Error when deleting tables or when modifying column names in the tabular model
Hi, I am using tabular model level 1500. I have a postgres database that is connected to the azure analysis server through an on prem gateway. I have used powerquery to fetch data from the postgres database (via an odbc driver) to the model. I was able…
Unable to access the Azure Analysis services from Visual studio application
Hello All, I have deployed an Azure Analysis Service and enabled the firewall and Power BI. Users are able to access the Azure Analysis Service from Power BI, but they are unable to access it via Visual Studio from their desktops, receiving a network…
Analysis Services taking too much time to refresh SSAS tabular model
Hi, I have a data set of somewhere 40M records in SSMS. My tabular model earlier use to get refresh on S1 tier with 25-30 min. But now I'm using S2 tier and even still its refreshing the data at approx 60 min or sometimes failing and showing timeout…
How to change audience in token used for Azure Analysis Services REST API?
We use the Azure Analysis Services REST API to trigger model updates and refreshes. We received the following email from Microsoft indicating that the audience for the token used to make those requests needs to be changed. You’re receiving this notice…
To Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS)
I'm not able to Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS), even though the MS Azure page here https://zcusa.951200.xyz/en-us/azure/analysis-services/analysis-services-datasource#tab1400a has given an option to read delta…
RLS on Azure Analysis service
I have a fact table and 3 dim table partner ,region and user and my user table contains the usernames and there respective access i:e user1 amazon and America , user2 flipkar and canada , so when ever user 1 logs in he should only see amazon and America…