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