Here are the current conditional formatting capabilities. https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/

I believe this is going to be improved upon so it will be more data driven in the future.

You could probably do it with a nested iif statement make the false part of that nested iif statement your alternating row color expression.

Analysis Services will automatically create the parent child dimension for you when you put the table through the wizard. You just point it to your key column and your...

You can set the .odc file that is created when you create the connection to auto refresh everytime that excel file is open or you can just hit the refresh...

sqlshare.com has a lot of videos. Give that a shot.

Strange... sounds like you should be good from what you've listed here. If you open the ODS connection and hit Test Connection your able to connect?

I usually...

I've had similar problem with reports that use an AS dataset. The parameters in the second report are expecting MDX so make sure the parameter values that are being...

Can you check the ReportServer database to ensure nothing has been corrupted.

Do you get any kind of connection error or does the report just not display anything? Possibly a credentials issue on the AS side.

Have you tried using a split function to pass in multi values?

CREATE FUNCTION dbo.Split

(

@RowData nvarchar(2000),

@SplitOn nvarchar(5)

)

RETURNS @RtnValue table

(

Id int identity(1,1),

Data nvarchar(100)

)

AS

BEGIN

Declare...

You want to do a rowset action. It's a little more difficult to do in 2005 though. Here's a blog that walks you through it.

Try rewriting like this.

(ParallelPeriod([Date Pay And Benefits].[Fiscal Year].[Fiscal Year]

, 1

,[Date Pay And Benefits].[Fiscal Year].CurrentMember)

,[Measures].[Amount])

There is an processing option called Process Incremental that will allow you to write a query for just the rows you want to load in the cube.

If you're willing to travel to Tampa, Florida there is a free conference called SQL Saturday January 24th. I've been to two other SQL Saturday events and they're very...