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?

“Post and Print” function in Business CentralThe “Post & Print” function was removed since Dynamics NAV 2017, it has been replaced by the “Post & Send” function which allows you to do more things by configuring specific sending profiles.Now the newly posted document is opened after posting, you can print it from there …but if,…

über Post and Print function in Business Central — Roberto Stefanetti NAV & Business Central Blog

Here is another interesting use case of Row Level Security (RLS). It’s funny that my first post was also about RLS – when you use RLS, lot of different challenges show up (which are not relevant and do not have any use cases without RLS). In this post we are going to look at how […]

über Implement Row Level Security based on business rules in Power BI — PeryTUS IT Solutions

Power BIte: Turning datasets into dataflows

Sehr gutes Video. Hier wird auf anschauliche Weise gezeigt, wie einfach ein Dataset in einen dataflow ausgelagert werden kann, um so ein zentrales „repository“ aufzubauen…

BI Polar

At this point I’ve said „Power BI dataflows enable reuse“ enough times that I feel like a broken record[1]. What does this phrase actually mean, and how can you take advantage of dataflows to enable reuse in your Power BI applications?

This Power BIte video is a bit longer than its predecessors, and part of this is because it covers both the problem and the solution.

The problem is that self-service BI applications often start out as one-off efforts, but don’t stay that way. At least in theory, if the problem solved by the application was widespread and well understood, there would be an existing solution already developed and maintained by IT, and business users wouldn’t need to develop their own solutions.

Successful applications have a tendency to grow. For self-service BI, this could mean that more and more functionality gets added to the application, or it could…

Ursprünglichen Post anzeigen 286 weitere Wörter

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations can take advantage of specific optimisations. When RI issues exist in an IMPORT model, complex expressions will not be able to use all…

über Clean data = faster reports — Phil Seamark on DAX

This is a series of posts and exercises from a recent full-day workshop called Next Level Power BI. Check back for additional lessons and freely post your questions and feedback in the comments section after this post. Power Query is a modern data acquisition and transformation technology and it is the „Get Data“ component of Power BI and many other Microsoft tools. The query script language of Power Query is known as „M“ or the Microsoft Data Mashup language. The menu options and selections in the Power Query Editor interface build this „M“ script for you but to use Power Query at an expert level, you must understand fundamental concepts of the language. The post will step you through some essential mechanics of the language to build the necessary fundamental skills.

über Next Level Power BI – M Language Basics — Paul Turley’s SQL Server BI Blog