Skip to content

Insight Quest

Brett Powell's Data & Analytics Blog

  • Home
  • Frontline Analytics
    • On-Site Training
    • BI Assessment
    • Corporate Site
  • Insight Quest
    • Tech Event Schedule
    • Boston BI User Group
    • Power BI User Group – Data Access
  • Resources
    • MSBI Books

Day: November 2, 2017

Integrated Product Dimension Query

November 2, 2017 Brett Powell

Remaining Task: Revised Product Query In last week’s blog post, Brett’s top remaining work item for Sprint 12 was to revise the product dimension query.

Continue reading

Analyze SQL Server Query Store with Power BI

November 2, 2017 Brett Powell

SQL Server and Power BI Collaboration Earlier this week at PASS Summit 2017, Erin Stellato, Principal Consultant with SQL Skills, delivered a pre-conference session regarding SQL

Continue reading

Trailing Period M Queries

November 2, 2017 Brett Powell

Trailing History Requirements A common requirement for fact tables and BI queries generally is to retrieve a specific date interval relative to the current date.

Continue reading

Blog Archive

Blog Topics

Tags

Analysis Services DAX Excel M MSBI Power BI Power BI Administration Power BI Desktop Power Pivot Power Query SSAS Tabular

Enter your email address to follow this blog and receive notifications of new posts by email.

Insight Quest

Blog Post History

November 2017
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« Oct   Dec »

Five Popular Posts

  • Analyze SQL Agent Job History with Power BI
    Analyze SQL Agent Job History with Power BI
  • Power BI Admin Datasets
    Power BI Admin Datasets
  • Power BI Artifact to Workspace Relationships
    Power BI Artifact to Workspace Relationships
  • Power BI Artifacts Per Workspace
    Power BI Artifacts Per Workspace
  • Refresh Power BI Datasets with PowerShell
    Refresh Power BI Datasets with PowerShell

Top 10 Power BI Blog for 2019

Top 10 Power BI Blogs Badge

Microsoft Power BI Partner

Blog at WordPress.com.
  • Subscribe Subscribed
    Insight Quest
    Join 345 other subscribers

    Have a WordPress.com account? Log in now.

  • Insight Quest
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar
Loading Comments...