Power BI

SQLServerCentral Article

Using Power BI to Analyze My Travels

  • Article

As a data professional, I have some fun with data in my life. I like numbers, and I like tracking things. I've written posts about my year in numbers, and recently noted the states I've visited. Like many of you, I've sometimes used this data to practice a skill, maybe learn to ETL or query […]

5 (2)

You rated this post out of 5. Change rating

2023-07-14

2,461 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 22: Time Intelligence – Dates Functions: The DAX NEXT() Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces four very similar DAX Time Intelligence functions related to Date: NEXTDAY(), NEXTMONTH(). NEXTQUARTER() and NEXTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,105 reads

Technical Article

Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security

  • Article

In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.

You rated this post out of 5. Change rating

2024-01-09 (first published: )

Blogs

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Refreshed in Tuscany

By

I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t...

The Community is YOU, Not Any Organization

By

As I type this, we’re leaving behind spring, and all the amazing events that...

Read the latest Blogs

Forums

SSIS task that runs a PowerQuery

By pietlinden

is there a good tutorial on how to get SSIS to run a PowerQuery...

Sub Queries Optimization

By ralahari

(SELECT Column1 FROM Table1) as --5 Table1_1 ON table3.Column1  = Table1_1.Column1 LEFT JOIN (SELECT...

UNION ALL Optimization

By ralahari

select Colum1 , Colum2  from  table 1 Union All select Colum1 , Colum2  from ...

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers