Stack Overflow
Stack Overflow

Questions tagged [bism]

The Business Intelligence Semantic Model (BISM) is a single unified BI platform from Microsoft

MSDN - https://msdn.microsoft.com/en-us/library/jj735264.aspx

10 questions
4
votes
0 answers

Add azure ad group to tabular model in visual studio

I try to add a azure ad group to a Role to a tabular model in Visual Studio. I have tried both to add the group through the visual studio (find user in the role editor) and change the code itself. But I get the same error when I try to open the…
Tysklind-MSFT
  • 87
  • 6
3
votes
2 answers

Count of Rows Based on Their Most Recent Value in Excel PowerPivot Using DAX

Is it possible to get a distinct count of rows based on a field's most recent value in a PowerPivot table using DAX? I have a transactional table that tracks professionals with hire and transfer dates. I would like to get a count of the…
dotNetE
  • 616
  • 1
  • 6
  • 27
1
vote
1 answer

Using DAX to format a currency based on a format string stored in a dimensions

I have a sales fact 'Sales' from multiple countries and I have a measure created in that fact table called 'Sales'[Revenue] I'd like to create one measure that dynamically formats based on the the country, so US sales would be formatted $100 and UK…
user2637453
  • 345
  • 1
  • 3
  • 9
1
vote
1 answer

an error occurred during an attempt to establish a connection to the external data source

I have one Tabular SSAS project & I have deployed it on SQL Server Analysis Service 2012. Then I have created a BISM connection to that deployed project as in following way. Then I have created one PowerPivot excel report out of that BISM workbook…
Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35
1
vote
2 answers

How can I create filter based on two different fields with OR operator between them in Power View?

For example I want to filter my data based on next filter expression: lead_veh_of_interest starts with 'BMW 1' OR sale_model starts with 'BMW 1' how can I achieve this?
Andrey Morozov
  • 7,839
  • 5
  • 53
  • 75
0
votes
0 answers

Is it possible to skip only certain columns with different definitions when performing schema-only update of Power BI Database?

Scenario: I have a Power BI database/report that uses incremental refresh. I am trying to automate the update of this DB schema (the .pbit file) to include in our CI/CD pipeline. I've looked at using the MicrosoftPowerBiMgmt PowerShell module,…
jalopy67
  • 3
  • 3
0
votes
1 answer

Issue with Summarize in SSAS 2014 data model

Good Day all. I really hope someone can assist with this. The following code works great in DaxStudio and returns a topn…
smckechnie
  • 79
  • 7
0
votes
1 answer

Next available Date

I have a tubular model that has a standard star schema On my dim date table there is a column that flags UK holidays I would like to not included this date if a key chooses a date that has been flagged but the next availble date I don't have much…
user2181700
  • 147
  • 3
  • 15
0
votes
1 answer

SSAS - Time Intelligence is not working in Tabular Model

I have a separate date dimension marked as Date table in Tabular Model and having proper relationship with another table(e.g SalesTable) with column of date type. But still time intelligence functions are not working. I am using the date column from…
BI_Help
  • 1
  • 1
0
votes
2 answers

Conditional distinct count based on a measure in DAX

I am trying to do this with DAX and unable to get the correct distinct count... AccountID OrderDate Product SalesAmount DiscountAmount 1023 Nov-14 Product001 $0 $5.00 1045 Nov-14 Product001 $30.00 …
sameer
  • 163
  • 2
  • 6