Is there any equivalent in PBI for data...

Is there any equivalent in PBI for data...

I'll guess since you didn't post a way for anyone to post tested code.

Use LEAD to access subsequent data in the current row. Then compare AgentExpDate to the LEAD value...

This?

DECLARE @String VARCHAR(MAX) = '(abc.domain.com)'

SELECT @String,SUBSTRING(@String, CHARINDEX('(', @String) + 1, CHARINDEX(')', @String) - CHARINDEX('(', @String) - 1)

To get the quarter you can use a calendar table that has the quarter specified for each day(if you have one).

Or something like this.

SELECT

CASE MONTH(GETDATE())

WHEN 1 THEN 'Qtr1'

--etc

WHEN 7 THEN...

• This reply was modified 1 year, 1 month ago by Chrissy321. Reason: typo

Provide error message as text masking any identifying information.

Yes I was talking about the Tabular Editor product. Better answer would be query MDSchema_Cubes

SELECT * FROM $system.MDSchema_Cubes

The docs look wrong since LAST_SCHEMA_UPDATE and LAST_DATA_UPDATE have the same description.

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms126271(v=sql.110)

Best answer...

You can run Tabular Edit with the appropriate permissions to connect to your prod server. Then...

You can run Tabular Edit with the appropriate permissions to connect to your prod server. Then...

Does this help?

https://sqldusty.com/2011/08/01/ssrs-expression-iif-statement-divide-by-zero-error/

Why SSRS? Do you need user interaction?

If you don't need user interaction then there are better ways to do this. SSRS is for creating formatted output so I am not...

This sounds like more of an asp.net application issue rather than a SQL issue. I would not store links in the database. When you the user clicks the initial page...

This is tsql

DROP TABLE IF EXISTS #Roles;

SELECT * INTO #Roles FROM OPENROWSET

(

'MSOLAP',

'Data Source=localhost;Initial Catalog=YourSSASDatabaseName;Provider=MSOLAP.4;Integrated Security=SSPI;Format=Tabular;',

'SELECT * FROM $System.TMSCHEMA_ROLES'

);

DROP TABLE IF EXISTS #RoleMemberships;

SELECT * INTO #RoleMemberships FROM OPENROWSET

(

'MSOLAP',

'Data Source=localhost;Initial Catalog=YourSSASDatabaseName;Provider=MSOLAP.4;Integrated Security=SSPI;Format=Tabular;',

'SELECT...

You can issue an MDX query or a TSQL query against a linked server.

https://www.sqlshack.com/linking-relational-databases-with-olap-cube/

This?

SELECT * FROM $System.TMSCHEMA_ROLES

SELECT * FROM #TMSCHEMA_ROLE_MEMBERSHIPS

• This reply was modified 1 year, 5 months ago by Chrissy321. Reason: Added second select