Links, Links, Links

Man möchte eigentlich meinen, in der Sommerzeit hat man mehr Zeit zum Lesen interessanter Beiträge. Bei mir ist es genau umgekehrt, da ich mich in dieser Jahreszeit gerne und viel an der frischen Luft bewege. Trotzdem habe ich mal wieder einige interessante Beiträge zusammen getragen. Ein bunter Reigen, der zeigt, was mich so alles interessiert…

Read and Write Excel files in real-time with R in SQL Server 2017

Power BI Regression Report

API:

https://www.programmableweb.com/news/bing-maps-time-zone-api-now-generally-available/brief/2018/08/15

https://www.programmableweb.com/news/how-to-access-any-restful-api-using-r-language/how-to/2017/07/21

https://www.programmableweb.com/api-university/api-developer-training

 

PowerApps progress bar

Using Azure Functions in PowerApps

SQL table to HTML

 

xRMVirtual User Group

Need Icons?

Microsoft Flow blog

Solving Real World Scenarios with Microsoft Flow – Challenge No. 4

Microsoft Flow has become a tool for daily business for me. Although I’m doing a lot of database related stuff still with SSIS I like to use flow whenever possible. This time I did the following:

+ Watch an ftp folder for new files arriving

+ Parse XML file content into variables

+ Send an e-mail with the result of the XML file to the customer

What really surprised me was the fact that in this special case it was much easier to do this in Flow rather than in SSIS.  For example SSIS is not natively supporting ftps. In flow it is as easy as this:

What I also liked is the fact I could do my work without having to touch the customers server. The final solution looks pretty an lightweight:

The ideas for achieving this I got from this two resources:

http://buildsharepointconcepts.blogspot.com/2018/05/parse-xml-using-microsoft-flow.html

https://baizini-it.com/blog/index.php/2017/12/07/microsoft-flow-uploading-daily-foreign-exchange-rates-from-the-european-central-bank/

 

 

PowerApps and Flow – Learn from the experts

Great video and walk-through showing the capabilities of PowerApps together with Flow:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/help-desk-install?utm_source=twitter&utm_source=t.co&utm_medium=doc&utm_medium=referral&utm_campaign=2018_04_19

Another great article here shows how to generate pdf documents:

http://johnliu.net/blog/2017/10/generate-any-pdf-documents-from-html-with-flow

 

Lesestoff für kalte Winterabende

Mal wieder etwas Lesefutter, hat sich in letzter Zeit bei mir so angesammelt:

Microsoft Flow – Laufende Summe über einen Wert bilden:

https://flow.microsoft.com/en-us/blog/calculate-running-totals-and-tracking-maximum-values-in-flow/

Power BI Blog mit technisch anspruchsvollen Artikeln:

https://www.poweredsolutions.co/2018/01/12/power-bi-custom-connector-languages/

Power BI / Excel BI exam scheinen  nun offiziell verfügbar zu sein (vorher beta):

https://www.microsoft.com/en-us/learning/exam-70-778.aspx

https://www.microsoft.com/en-us/learning/exam-70-779.aspx

Power BI decision tree:

https://www.mssqltips.com/sqlservertip/5249/data-exploration-drill-down-and-analysis-using-decomposition-tree-in-power-bi-desktop/

Microsoft Dynamics NAV 2018 New features:

http://www.dynamics-consultants.co.uk/blog/microsoft-dynamics-nav-2018-new-features

Und noch was zum Anschauen

Microsoft Integration Tools

Das ist ein Blog vollgepackt mit Ideen und Praxisbeispielen zu Microsoft Integrationsprojekten, viele Infos über Logic Apps, Azure functions etc.

http://microsoftintegration.guru/blog/

Auch hier gibt es „tons of“ Infos zu Logic Apps usw.

https://www.codit.eu/blog/

Und auch hier findet man tolle Beispiele mit Logic Apps:

http://www.tech-findings.com/2017/06/Inserting-data-in-On-Premises-SQL-Database-using-Logic-Apps.html