Microsoft Dynamis BC
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.
Short recap of the edX course Developing Business Applications with Power Apps and Microsoft Flow
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 course is outdated regarding user interface and especially the parts dealing with CDS (old version 1.0 in tutorial).
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