Olivier Travers

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

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   

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 possibly 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   
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   

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

1 2 3 … 178 Next »

RSS Feed

  • RSS - Posts
follow us in feedly

Elsewhere

  • Twitter
  • LinkedIn
  • GitHub

Latest Posts

  • Creating Cross-Database SQL Views via Stored Procedure from Power BI – Wait What? July 6, 2022
  • Non-Obvious Functional Behavior in Power BI Deployment Pipelines July 5, 2022
  • Limitations of On Premises SQL Sources with the Microsoft Power Platform July 3, 2022
  • How to Get DAX Query Results Out of Power BI… Without Writing Any DAX or Code June 25, 2022
  • Connecting to Power BI Datamart and PowerApps Dataverse’s SQL Server from Desktop Tools and External Services June 4, 2022

Categories

Entries by Date

August 2022
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Jul    
Copyright 2000-today - Olivier Travers
Ribosome by GalussoThemes.com
Powered by WordPress