War wohl nichts:

Jetzt läuft das Ganze unter dem Namen Project Oakdale


Everything you need to know about Project Oakdale


Ok, das ist mal wieder eine Fussnote wert. Wie es scheint gibt es „big news“ im Bezug auf Common Data Service oder besser Microsoft Dataflex. Eine ausführliche Abhandlung habe ich hier gefunden:

Dataflex is more (and less) than CDS

Business Central Virtual Event

Konnte gestern etwas in den Event reinschauen:


Vor allem hat mich dieser Beitrag interessiert. Ich finde die Integration mittlerweile als sehr gelungen.

Vor allem die Roadmap ist für mich von Interesse. Virtual Entities machen es in der Zukunft möglich, NAV-Daten ins CDS virtuell bereit zu stellen. Es sollen sogar CRUD Operations möglich sein. Das macht für mich vor allem bei der Entwicklung von Hilfstools in PowerApps viel Sinn.

Hier noch ein paar Infos zu aktuellen Stand der Virtual Entities sowie zum Gegenstück in AL:

Create and edit virtual entities that contain data from an external data source

AL Table Proxy Generator

Needful things – Oder was man so brauchen kann

Microsoft Dynamis BC

Company Badge

Disable Export to Excel

Interfaces in AL

Create a Role Center Headline

Integrate Business Central On-Prem with Flow

Business Central integration with Common Data Service

Learning Dynamics 365 Business Central Development From Scratch

Smart Notifications Code Sample

build Proxy in memory

Using Power Platform Dataflows to extract and process data from Business Central



How To Convert a Power BI Dataset To a Power BI Dataflow

Solving Real World Scenarios with the Microsoft Power Platform

Time to play with dataflows. I have the following situation. For transactions in foreign currencies I need accurate fx rates. Can a dataflow solve this requirement?

First thing I did was to subscribe for a free plan here:


Then in Power BI service I created my very first dataflow. Basically the flow consists of one simple api call (well described on the fixer page):

And with some basic steps in the Power Query editor I ended up with this:

Now I can link every transaction in foreign currency to my central fx rates table. This is great but there was one important thing missing. I couldn’t figure out a way to store the results like it is possible with the streaming dataset feature.

So I was searching for an alternative solution. Why not use CDS for application to store the data? And then point the Power BI dataflow to the CDS entity:

I created a new entity as I could not find an existing one in the standard cds entities:


Afterwards I created a custom connector to the fixer api:


Next thing I needed was a flow to pull the data in my newly created entity:

And last of all I created another dataflow in Power BI pointing to the CDS entity:


Now I have the result I was looking for. A central fx rates table with historical data.

I have to admit figuring out all of this was fun. And best of all I could solve a real business need.



Developing Business Applications with Power Apps and Microsoft Flow

Short recap of the edX course Developing Business Applications with Power Apps and Microsoft Flow

The good:

The course was a great starting point for me. The video tutorials are short but nevertheless full of information. I also found the labs interesting and fun.

The bad:

The course is outdated regarding user interface and especially the parts dealing with CDS (old version 1.0 in tutorial).



PowerApps Training

What a great day at Microsoft Zürich, I was happy to attend the Train the Trainers PowerApps partner workshop:

Canvas app design vs. model driven:

And if you want to get started with PowerApps this great tutorial will help you a lot