This looks like a perfect real-world scenario for me. In the last few months I have moved a lot of my personal resources to Azure. Inspired by this article I will try to build an Azure Management Tool with PowerApps
https://zimmergren.net/developing-with-azure-part-4-resource-explorer/
An incredible resource. So many topics and questions are handled here. This is probably the most interesting read I have seen for a long time.
http://www.jamesserra.com/archive/2020/10/top-azure-synapse-analytics-and-power-bi-questions/
A month end procedure is a regular topic to be covered when implementing finance with D365 BC. Some finance systems throw a user into a defined routine but with D365 BC it’s much more simplistic. To remove the need for users to be experts wouldn’t a defined routine be useful?
Here is the goal: Create a Power Automate flow that will handle the month end procedure in BC with minimal user input. Principal thing here is that month end is routine so why not have something to cater for it. Caveat here being that job knowledge makes up for a big portion of this finance process so not all of it can be catered for. The scope is laid out in the next paragraph.
So what makes up a month end in BC and what is the scope of this procedure?:
Ursprünglichen Post anzeigen 847 weitere Wörter
Back in August I highlighted the new dataflows PowerShell script repo on GitHub. These scripts provide an accelerated starting point to working with the dataflows REST APIs and to automate common dataflows tasks. This week the dataflows team has released two new REST APIs for managing dataflows transactions (think „refresh“) and a new parameterized PowerShell […]
Automatically refresh dataset when dataflow refresh completes — BI Polar
Leider konnte ich live größtenteils nicht dabei sein, aber mittlerweile sind die Sessions ja hier zum Abruf bereit:
This trick was demonstrated in my last session at RADACAD channel: https://youtu.be/xoR-2NjZCCk?t=977
The idea is basically to copy the entire report (pages, filters, bookmarks,…) between two different Power BI Desktop files (.pbix).
Why this is useful? Imagine you are building a new Power BI Report and you need to reuse the entire layout from another report not only the visuals but also the layout, pages, themes, custom visuals,… Yes the dataset will be different and the report visuals will stay in an error state like this:
Yes it seems broken , but the entire layout is there and is easy to change the field of a visual to a new field of the target dataset by drag & drop a new field
To do this you just need to follow these simple steps:
Copy the Report folder from…
Ursprünglichen Post anzeigen 63 weitere Wörter
Second post in the „Doing Power BI the Right Way“ series. In a business intelligence solution, data must be shaped and transformed. Your data is rarely, if ever, going to be in the right format for analytic reporting. Continue reading →
über Doing Power BI the Right Way: 2. Preparing source data — Paul Turley’s SQL Server BI Blog
Da gibt es einiges zu tun für mich. Klar ist dabei, dass das Vorbereiten auf die Prüfung im Vordergrund steht. So zwinge ich mich selbst am Ball zu bleiben…
https://docs.microsoft.com/en-us/learn/certifications/exams/pl-100
Announcing three new Microsoft Certifications for Business Applications
https://docs.microsoft.com/en-us/learn/certifications/exams/mb-800
War wohl nichts:
Jetzt läuft das Ganze unter dem Namen Project Oakdale
https://www.zdnet.com/article/microsoft-looks-ready-to-abandon-its-new-dataflex-low-code-brand/
Ok, das ist mal wieder eine Fussnote wert. Wie es scheint gibt es „big news“ im Bezug auf Common Data Service oder besser Microsoft Dataflex. Eine ausführliche Abhandlung habe ich hier gefunden:
For this blog, I want to share a technique that allows you to use tools such as Visual Studio Code to connect to and make changes to Power BI models. 1.515 weitere Wörter
über Using Visual Studio Code with Power BI — Phil Seamark on DAX
