Azure SQL Database
An Azure relational database service.
5,414 questions
2 answers
Azure Analysis Services: Not able to connect to data source(SQL server) with Active directory(In Model.bim)
In credential section of Model.bim we define the way we are going to authenticate the data source(here SQL server) , right now i'm using DB user, DB password with AuthenticationKind="UsernamePassword" and it is working fine and able to refresh…
asked 2020-12-30T09:44:52.797+00:00
![](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(297.6, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pieboy
1
Reputation point
commented 2021-01-07T15:45:31.807+00:00
![](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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,791
Reputation points Microsoft Employee
0 answers
Get record count of Partition
I have a partition processor in C# that creates and loads partitions in a 2 year rolling pattern once a day. When a partition is created with 0 records it is a valid partition and on subsequent loads, the partition state is checked and if Ready, it is…
asked 2020-12-10T07:05:43.827+00:00
![](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(80, 98%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bowles, Mickey
46
Reputation points
commented 2021-01-06T19:05:42.757+00:00
Bowles, Mickey
46
Reputation points
2 answers
Connecting Azure Analysis service and SSIS using service principal
Hello Team, We are trying to connect azure analysis services and SSIS using service principal. But when we are passing this in SSIS as username & password, it is getting failed again and again and throwing the below error : Test connection failed…
asked 2020-12-16T08:48:35.223+00:00
![](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(233.6, 77%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dheeraj
6
Reputation points
commented 2020-12-29T11:16:59.22+00:00
![](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(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
2 answers
One of the answers was accepted by the question author.
Actions in Analysis Services Tabular
One of the multidimensional feature not already available in tabular is the possibility to create actions. is there a roadmap about this feature?
asked 2020-12-22T09:27:47.07+00:00
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
accepted 2020-12-24T08:11:02.147+00:00
Anonymous
2 answers
One of the answers was accepted by the question author.
Filtering data before loading in Dataset from Tabular Model
Hi All, I have created a Tabular Import Model with last 5 years of data which has approx 10 Miliions of rows which is required for trend reporting. Now I am trying creating a Power Bi Desktop report for last say last 7 days, where I have Date…
![](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, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Ways to dynamically add a new column into Azure Analysis services
Hi All, Background, Power BI > Live connected to Azure Analysis Services > connected to Azure SQL Db I have instances where I need to introduce a new column after pivoting a key Attribute Value table i.e Next time around a new…
![](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(35.2, 24%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Cannot deploy Tabular Model to AAS server due to invalid PostgreSQL credentials
Hello, I am having problem with cube deployment which is built on PostgreSQL database. Every time I try to deploy the model to AAS server, I receive following error: Cannot process database. Reason: Failed to save modifications to the server. Error…
asked 2020-12-07T15:57:00.3+00:00
![](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(108.80000000000001, 40%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Matthew
121
Reputation points
commented 2020-12-11T12:50:55.41+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
1 answer
I can't update my Azure Analysis Services model
Hello, I lost my original file from my local laptop where I initially created my AAS model, so I went to the portal and downloaded the last deployed one : Now at first I was able to modify my measures and save my work but suddenly the…
asked 2020-12-07T15:18:03.273+00:00
![](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(19.2, 47%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Adnane KHIRCHI
6
Reputation points
commented 2020-12-10T08:35:28.707+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
What does the command ExternalCommandTimeout do?
I have a cube that crashes about 45 minutes in the processing and I got the tips to set the ExternalCommandTimeout default 3600 seconds to a much higher value, and it worked, the cube does now process completly. But what does it really do, what kind om…
![](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(89.60000000000001, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
1 answer
the 'transactionId_s' field and 'transactionId_g' field in waf log
Why in my exported app gateway waf log, field 'transactionId_g' has a value and field 'transactionId_s' has no value?
asked 2020-09-04T02:58:26.707+00:00
![](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(176, 34%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZD%3C/text%3E%3C/svg%3E)
Zhang, Di
21
Reputation points
commented 2020-12-04T10:08:25.137+00:00
suvasara-MSFT
10,026
Reputation points
0 answers
Table.NestedJoin in Azure Analysis Services
We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when we try to use that same command in Azure Analysis Services. Does this command even work in AAS? I don't see any examples of it working properly. Is…
asked 2020-11-19T23:25:27.723+00:00
![](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(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
161
Reputation points
commented 2020-12-02T20:00:32.137+00:00
![](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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services - current connection metrics
I am doing load testing of Azure analysis services where I have established 500 different sessions. When my code was running for these 500 connections, I monitored current connections metrics on Azure portal. There I saw max 15 current…
asked 2020-11-19T07:26:24.13+00:00
![](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(294.40000000000003, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kalpana Chauhan
21
Reputation points
accepted 2020-11-26T15:47:46.077+00:00
Kalpana Chauhan
21
Reputation points
0 answers
Building data model (schema) from data in PowerBI (or via export to Excel)
Hi, I am seeking to build a data model (schema) for data tables that I currently have in PowerBI. I am able to export the data to Excel but have been having issues building a schema for the tables. Would appreciate any help for this please. Thanks!…
asked 2020-11-22T23:35:50.333+00:00
![](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, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rishi Sumit
1
Reputation point
commented 2020-11-25T20:33:24.027+00:00
![](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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,061
Reputation points
1 answer
Accoun Intelligence Azure Analysis services
Hi, Is there an equivalent of "Account intelligence" functionality available on Azure Analysis Services? If not, can you describe a workaround as to how to implement this? Many thanks
asked 2020-11-18T10:12:30.483+00:00
![](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(12.8, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
Omar Ali
1
Reputation point
commented 2020-11-23T07:00:08.957+00:00
PRADEEPCHEEKATLA-MSFT
85,351
Reputation points Microsoft Employee
0 answers
Issue with method that returns Analysis services model
Hello, I have issues with extraction of model from Azure Analysis Services server using Powershell/C# methods and classes. In some cases, for some databases/cubes (no differences in the configuration itself), it returns empty Model (like there would…
asked 2020-11-10T09:49:43.36+00:00
![](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(278.4, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Karol Kolodziejczyk
6
Reputation points
commented 2020-11-17T08:36:30.437+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
One of the answers was accepted by the question author.
Configure Azure Log Analytics agent to OMS log analytics gateway with powershell
Hi, as title says is it possible to Configure Azure Log Analytics agent(on-prem) to log analytics gateway with Powershell. I know what is possible to do with netsh winhttp set proxy <proxy>:<port> but then I think all…
![](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(259.20000000000005, 56.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
1 answer
How to configure VNet IP address range to firewall setting in Azure Analysis Services
I would like to restrict access of Azure Analysis service from IP address range as configured in Virtual Network setting. My query is that How to configure VNet IP address range to firewall setting in Azure Analysis Services Any reply will be…
asked 2020-11-09T15:31:06.963+00:00
![](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(268.8, 51%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Krishna Dubey
21
Reputation points
commented 2020-11-13T00:47:47.653+00:00
MartinJaffer-MSFT
26,061
Reputation points
2 answers
Migrate a PBIX to Azure Analysis Services
I want to import a Power BI PBIX file into Azure Analysis Services. I don't see any recent information on how to do that. Is it possible? If so, how?
asked 2020-10-29T15:09:09.963+00:00
James H. Robinson
161
Reputation points
answered 2020-11-10T20:27:06.473+00:00
James H. Robinson
161
Reputation points
1 answer
Updating the Measure NullProcessing property through not updated in the cube while opening from SSDT
HI, I would like to update the NullProcessing property from Automatic to Preserve foreach (MeasureGroup measureGroup in cube.MeasureGroups) { foreach (Measure measure in measureGroup.Measures) { measure.Source.NullProcessing =…
asked 2020-10-23T07:36:16.003+00:00
![](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(284.8, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Narendra Reddy
1
Reputation point
commented 2020-11-10T12:49:15.7+00:00
Narendra Reddy
1
Reputation point
1 answer
One of the answers was accepted by the question author.
How to connect Azure analysis service from excel and powerBI online app using office 365
PowerQuery is not available in office 365 excel online version and unable to connect with Azure analysis service. while I can connect to Azure analysis service using Get Data in Excel desktop version but same feature is not available in online…
asked 2020-10-27T12:34:29.827+00:00
Krishna Dubey
21
Reputation points
accepted 2020-11-09T15:23:23.367+00:00
Krishna Dubey
21
Reputation points