ERP and BI

Schlagwort: Microsoft Flow

  • Links und Lesestoff für laue Sommerabende

    —

    by

    selfservicebi
    in ,

    Es gäbe so viele interessante Berichte, die ich gerne studieren würde. Nur leider fehlt mir im Moment komplett die Zeit. Hier eine kleine Auswahl der Artikel, die ich mir vorgemerkt habe. Hoffe, dass ich das in den paar Tagen Urlaub, die mir bevorstehen, nachholen kann : https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-create-server http://www.talavant.com/blog/2016/12/12/ssis-data-streaming-destination-to-powerbi https://powerusers.microsoft.com/t5/Connecting-To-Data/Execute-Stored-procedure-with-On-Premises-Gateway-server/m-p/9429#M630 https://parserr.com/ https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-and-Microsoft-Flow-Monitoring-your-data/m-p/203049 https://dhexcel1.wordpress.com/2017/07/20/excel-super-links-103-shared-by-david-hager/ https://azure.microsoft.com/en-us/blog/super-charge-power-bi-with-azure-analysis-services/?utm_content=bufferfa2d5&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer Exporting Power…

  • Microsoft Flow – New Approval feature

    —

    by

    selfservicebi
    in

    I really like to try things out. And the new Approval features looks really promising. A very good video can be found here:   What caught my attention was this picture- the perfect scenario for a new challenge: I will try to solve the highlighted items as follows: View Sent requests and view my history:…

  • Microsoft Flow App for Windows 10 phone – Beta

    —

    by

    selfservicebi
    in

    Finally, a Microsoft Flow App for Windows 10 phone, apply here: https://www.onmsft.com/news/microsoft-flow-windows-phone-app-now-available-via-a-new-beta-program

  • Solving Real World Scenarios with Microsoft Flow – Challenge No. 3 – Part two

    —

    by

    selfservicebi
    in

    To get things started I use a simple daily schedule – nothing special here: Then I drag a Data Operations – Compose step on the flow. I use this to calculate the previous day. I have found out that I have to enter the expression with leading and trailing double quotes as otherwise it won’t…

  • Solving Real World Scenarios with Microsoft Flow – Challenge No. 3

    —

    by

    selfservicebi
    in

    So I really like playing around with Microsoft Flow. In this „challenge“ I did basically the following: Calling the fixer api on a daily basis Parse the JSON reponse do some logical tests Send myself an e-mail with the current fx rates Add the content to a Power BI Streaming dataset Although the result looks…

  • Microsoft Flow – Parse JSON messages

    —

    by

    selfservicebi
    in

    As stated here Microsoft Flow now supports Json: https://flow.microsoft.com/en-us/blog/five-services-json-http/ So I was eager to try it out. Created a simple Flow with the new Action „Parse Json“.  But ran into the following error: So I did a search in the Microsoft Flow Forum and fount this thread: https://powerusers.microsoft.com/t5/Flow-Forum/Error-from-Parse-JSON-step-when-Updating-Flow/m-p/21462/highlight/true#M5093 It seems that this new feature is…

  • Microsoft Dynamics & Microsoft Flow

    —

    by

    selfservicebi
    in

    How to create your first Flow for NAV

  • Solving Real World Scenarios with Microsoft Flow – Challenge No. 2

    —

    by

    selfservicebi
    in

    This is the second challenge: + Periodically get currency exchange rates from a web service + Insert the rows in a staging table (SQL Database On-premise) + Parse inserted Json Data with a stored procedure and insert results in our final Currency Exchange Rates Table. The resulting Flow would look like this: Let’s get things…

  • Solving Real World Scenarios with Microsoft Flow

    —

    by

    selfservicebi
    in

    This is my first post in English. The reason is I’m using an API named EU VAT API provided by chema. Up to now for me Microsoft Flow was just one new hot thing offered by Microsoft. But this article has inspired me to challenge Flow with a real-world requirement. One common task in Europe…