Olivier Travers

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

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   

Non-Obvious Functional Behavior in Power BI Deployment Pipelines

I’ve been spending time lately trying to get a deployment pipeline to work for one of my clients and ran into a couple of non-intuitive limitations that I didn’t expect,… Read more »

Power BI   

Limitations of On Premises SQL Sources with the Microsoft Power Platform

On the surface it may look like Microsoft’s data gateway provides an even playing field between IaaS and PaaS approaches with regards to SQL hosting, i.e. you can run your… Read more »

Power BI   

How to Get DAX Query Results Out of Power BI… Without Writing Any DAX or Code

Power BI’s DAX language is often described as “simple but not easy.” While visuals such as tables and matrices generate a lot of DAX behind the scenes, such as subtotals… Read more »

Power BI   

Power BI Dataset vs. Dataflow vs. Datamart vs. Dataverse vs. SQL Server vs. Synapse – Are You Confused Just Yet?

With the preview launch of Power BI datamarts in May 2022, there is yet another data entity to contend with in the Power BI ecosystem. I plan to update this… Read more »

Power BI   

Well Done Worldtimebuddy!

On most weeks I need to schedule meetings in several time zones that literally go from the US West Coast to the Australian East Coast, and I got into the… Read more »

best & worst practices, user experience   

Getting Started with the Dataverse API in Postman

This entry fills in the gaps of Microsoft’s official documentation as I had to go through a fair amount of trial and error to get things going. It assumes general… Read more »

Power BI   

Which Languages Should You Learn as a Power BI Developer?

Data-centric jobs are sitting by definition at the intersection of business and technology, and that affects who performs these jobs, their tools, and workflows. Traditionally data analysts tend to be… Read more »

Power BI   

Posts navigation

« Previous 1 2 3 4 … 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