Lesestoff / Linksammlung

Momentan habe ich echt viel zu tun, trotzdem gibt es immer mehr als genug neuen Lesestoff. Nachfolgend ein kleiner Auszug, muss zugeben, habe selber noch nicht alles gelesen. Aber dafür ist dieser Blogbeitrag ja da, sprich ich kann später nachschlagen…

Power Platform:

Codeunit API’s in Business Central

Power Apps Community Plan without Office 365

Using Power BI service without an Office 365 account

Currency Conversion in Power BI Reports

THE HIDDEN GEMS OF THE FUNCTION WEB.CONTENTS()

Moving X-Axis in Power BI

Analyzing PASS SQL Saturday data using Power BI

Paginated Reports Bonus Tutorial – Use the XMLA endpoint to create a live connected Excel table

https://www.fourmoo.com/2020/02/12/how-you-can-store-all-your-power-bi-audit-logs-easily-and-indefinitely-in-azure/

Read API Data with Power BI using Power Query

 

NAV Business Central:

Codeunit API’s in Business Central

Business Central Blog

Import Tenant Data

How to use the Excel Buffer in Business Central cloud

Another great BC Blog

And another great Blog….

Dynamics 365 Business Central Workflows Auto Posting Transactions

 

SQL:

SQL CROSS JOIN examples

Split Delimited String with Split Delimited with PARSENAME function

 

Azure:

Cloud ETL With Azure Data Factory & CDS

Custom Logging and Auditing of ADF Data Flows

Syncing on-premise databases to Microsoft Azure Cloud using Azure Data Factory

Azure Functions Live – Feb 2020

 

Office:

Typescript – The Excel VBA Killer?

Create a Star Schema Data Model in SQL Server using the Microsoft Toolset

Es wurde ja schon oft genug gesagt, auch in Power BI ist das A und O eines erfolgreichen Projektes ein gut durchdachtes Datenmodell. Hier mal ein Beitrag, der aus Sicht vom SQL Server zeigt, wie so ein Designprozess aussehen kann.

Create a Star Schema Data Model in SQL Server using the Microsoft Toolset

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. 2

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:

captur1

Let’s get things started:

HTTP: I’m using fixer.io to get my data. No Problem so far.

Insert Row: I have installed and configured the On-premises data gateway and it’s working.

Execute stored procedure: Here comes trouble:

capture

Sadly up to now stored procedures are no supported when using a gateway. But hopefully we get this feature soon as stated here.

I then figured out the following workaround. Create an AfterInsert Trigger on the staging table to transfer my data to the final table. But I had now luck:

capture2

After some investigation, I found this thread. Currently you can’t use the Insert Row action on a table with an existing trigger.

So, this is really bad. At present neither stored procedures nor triggers are supported when dealing with Microsoft SQL Databases via the On-premises data gateway. Challenge lost at least for the moment.