Olivier Travers

  • Home
  • About Me
Olivier Travers
Skip to content
  • Home
  • About Me

Business Intelligence Job Profiles – How to Play to Your Strengths, Find Your Niche, and Build Your Career

My post on which languages to learn as a Power BI developer resonated with many people so I thought I’d take a step back and write about how to navigate… Read more »

Power BI   

Aggregation Options in Power BI and SQL Server Analysis Services

Pre-computing aggregates from granular data to improve live performance for end users by using computing resources at scheduled times is a well-established software pattern. In this entry we’ll look at… Read more »

Power BI   

Searching Through an Ebook Collection with Everything and Calibre

This entry is a follow up to How to Find & Open Any File In a Jiffy with Launchy + Everything + Dopus, applied specifically to searching by title through… Read more »

cool tools   

Making Sense of Power BI Programmatic Options: REST APIs, PowerShell, TMSL, TOM, Tabular Editor Scripting

Back around 2015, Microsoft introduced the current Power BI platform to replace its “Power BI for Office 365” SharePoint/Excel-based offering that most people have long forgotten, with a focus of… Read more »

Power BI   

Plex Server Direct Connectivity Checklist

Plex Media Server can be a pain in the neck to get fully working with a direct connection between your clients, whether on your local network or remote, and your… Read more »

software   

Power Platform Extranets with AAD B2B Users: Using LastPass to Publish with Power BI Desktop; Dataflow & XMLA Access; And More!

No More Copying/Pasting Passwords in Power BI Desktop Unlike Office Microsoft 365 desktop applications, Power BI Desktop doesn’t keep track of more than one account at a time, which is… Read more »

Power BI   

Row Level Security, Object Level Security, Data Masking, Sensitivity Labels: What Are the Business Use Cases?

In a previous entry I explained at length the various ways to secure data in business intelligence products. In this follow-up I want to elaborate on which method(s) to use… Read more »

Power BI   

Getting the Most Out of Your Synology Networked Attached Storage: Did You Know It Can Do That?

While the initial consumer-grade NASes sold during the late 2000s/early 2010s had fairly weak CPUs and little memory, newer models priced in the $200-$500 range from about 2019 forward are… Read more »

cool tools, digital lifestyle   

Data-Driven Heaven in Power BI Using Field Parameters, Bookmarks, CSS, and Expression-Based Formatting

This week it just happened that two of my consulting clients needed a date dimension table so I started revising my base Power Query template to make sure it was… Read more »

Power BI   

Creating Cross-Database SQL Views via Stored Procedure from Power BI – Wait What?

Recently I wrote about things you can’t do on the Power platform when querying an on-premises SQL database. Specifically, I wanted to recreate views in a database that gets wiped… Read more »

Power BI   

Posts navigation

1 2 3 … 179 Next »

RSS Feed

  • RSS - Posts
follow us in feedly

Elsewhere

  • Twitter
  • LinkedIn
  • GitHub

Latest Posts

  • Business Intelligence Job Profiles – How to Play to Your Strengths, Find Your Niche, and Build Your Career January 23, 2023
  • Aggregation Options in Power BI and SQL Server Analysis Services January 18, 2023
  • Searching Through an Ebook Collection with Everything and Calibre January 11, 2023
  • Making Sense of Power BI Programmatic Options: REST APIs, PowerShell, TMSL, TOM, Tabular Editor Scripting January 5, 2023
  • Plex Server Direct Connectivity Checklist December 3, 2022

Categories

Entries by Date

January 2023
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Dec    
Copyright 2000-today - Olivier Travers
Ribosome by GalussoThemes.com
Powered by WordPress