Olivier Travers

  • Home
  • About Me
Olivier Travers
Skip to content
  • Home
  • About Me
W### T$$ F###

Row Level Security & Beyond in Business Intelligence Applications: A Practical Overview

The ability to filter data by user is critical whenever sensitive information is shared, whether internally to an organization or even more so externally. This is often known as “row… Read more »

Power BI   

Connecting to Power BI Datamart and PowerApps Dataverse’s SQL Server from Desktop Tools and External Services

The main appeal of Power BI’s new Datamart capability is arguably the fact it’s including a SQL Server instance that’s optimized for analytical purposes and is fully managed yet still… Read more »

Power BI   

SQL Performance Tuning for Power BI Devs Who Don’t Know Database Architecture

Many Power BI developers come from an Excel background and have little to no SQL experience. Yet SQL databases are pervasive data sources and there’s not always a database administrador… Read more »

Power BI   

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   

Posts navigation

1 2 3 … 179 Next »

RSS Feed

  • RSS - Posts
follow us in feedly

Elsewhere

  • LinkedIn
  • GitHub

Latest Posts

  • Row Level Security & Beyond in Business Intelligence Applications: A Practical Overview February 18, 2023
  • Connecting to Power BI Datamart and PowerApps Dataverse’s SQL Server from Desktop Tools and External Services February 2, 2023
  • SQL Performance Tuning for Power BI Devs Who Don’t Know Database Architecture January 31, 2023
  • 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

Categories

Entries by Date

March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Feb    
Copyright 2000-today - Olivier Travers
Ribosome by GalussoThemes.com
Powered by WordPress