Auch wenn ich immer mehr das Gefühl habe, dass ich einer der wenigen bin, den die neue BC Welt fesselt, möchte ich trotzdem auf dieses Projekt verweisen.
Es zeigt einen möglichen Weg, Daten aus Dynamics BC in einen Azure Data Lake zu bringen. Da hier viele spannende Bausteine verwendet werden (BC extension, Azure Storage Accounts, Azure Synapse Pipelines als ETL), ist das auch das perfekte Lernprojekt für mich persönlich.
https://github.com/microsoft/bc2adls
Yesterday Microsoft has officially presented the Business Central Universal Code initiative (http://aka.ms/BCUniversalcode). For more details about this initiative, I suggest to read Waldo’s post here or my old post on Simplanova’s blog here.
In summary, with this new offering, selling what is called “non-universal code” (alias extensions not targeted to work online) to new Business Central on-premise customers might require to license two additional modules from 2022 onwards (names of these modules are subject to change):
The non-universal code fees have a per full user (Premium or Essential) price with a per-year fee starting from 2023.
The announced timeline is the following:
Ursprünglichen Post anzeigen 809 weitere Wörter
Power BI dataflows (PBI dataflows) is a powerful data prep tool for you to transform data and reuse them in other places downstream. At the same time, while Excel is very popular among business users, there is still, at the time of writing this post, no out-of-the-box connector to import PBI dataflows to Excel. This post aims to solve that pain point.
This post also proposes an alternative to the existing PBI dataflows connector to Power BI Desktop to push the users‘ access control to the table level, instead of workspace level like the current connector.
Ursprünglichen Post anzeigen 1.453 weitere Wörter
This is definitely an area I will be putting a lot of energy into in 2022. Welcome to the new world.
I’ve written lot of time ago a post on how to save a file from Dynamics 365 Business Central SaaS to an FTP server. The solution can be found here.
After this post I’ve received lots of requests about how to do the opposite: if someone sends me a file on an FTP server, how can I retrieve the file, parse it and then save the data into Dynamics 365 Business Central SaaS?
There are certainly different ways for doing that, but (as promised in the past days to some of you) in this post I want to describe what I think it’s one of the best solution in terms of performances, scalability and reliability. The schema of the solution is the following:
Here, we’re using an Azure Logic App for connecting to an FTP server (via the FTP connector). The Logic App retrieves the content of the uploaded…
Ursprünglichen Post anzeigen 1.245 weitere Wörter
Im preparation for the PL-200 exam I decided to give the PL-100 exam a try.
https://docs.microsoft.com/en-us/learn/certifications/exams/pl-100
https://docs.microsoft.com/en-us/learn/certifications/exams/pl-200
And I’m pleased it worked out quite well
https://www.credly.com/badges/c0941099-5fdd-44a8-8652-0d309ed64d7a/public_url
You still have almost a month to sign up for the challenge.
Don’t miss the opportunity to get a free exam voucher.
Happy learning…
Power BI dataflows is a nice capability of Power BI. It’s actually not a new Microsoft product. If you use Excel and Power BI long enough, there is a big chance that you’ve already used Power Query at least once. And basically, to keep things simple, it’s just Power Query, but you have to edit it on a web-browser, in Power BI Service.
Pro license is your entrance ticket to use this nice capability. Although Premium licenses (per capacity or per user) provide more advanced features, many applications of Power BI dataflows are already available with Pro license. One of them is to store historical data, and of course, to show them in reports.
In this blog post, I will briefly introduce Power BI dataflows (with some useful links if you want to learn more). Next, I’ll share how to store historical data in your own storage account and show…
Ursprünglichen Post anzeigen 3.046 weitere Wörter
Inspired by this great video and as a follow up to my last post regarding the Mastering DAX workshop I want to tell you about my findings regarding the DAX language:
DAX is simple,
but it is not easy.
This is so true. When I was sitting in the classroom, I realized in every example we did how true this statement is. If you see a working DAX formula you are tempted to say: “OK, no problem, this is easy”. But making a working DAX measure – which is really working all the time – no matter what the user is doing in terms of filtering and grouping is hard work.
If your measure is working in one situation but not in all situations
then your measure was wrong from the beginning.
Again, in many cases it seems that a measure is working. But as soon as you are changing some parameters or add an extra step of complexity it is not working at all. In many cases this means go back to start and do your work again.
Stick with the basics
Don’t bother about sophisticated functions.
Put all your efforts into filter context, row context, iterations, and context transition. I am still learning the hard way that this is the only way to success.
You can’t learn DAX by copying formulas
or patterns from the internet or books.
I tend to learn new things by browsing the internet. If I find a solution which is pointing me in the right direction, I usually succeed in solving my problem. With DAX I first thought ok cool do it in the same way at sometimes it seems to work but unfortunately other times not. So learning the basics is so important not just insert some CALUCULATE command here and there.
You can’t learn DAX by reading books
Only by practicing.
I have bought quite a few books in the past and by studying them I was fooling myself. I thought I know enough about DAX now. But the truth is I knew nothing. As soon as you are doing real live examples you will realize that without a solid understanding of the basics you are caught in an endless try and error loop.
So having learned all of this I feel at least in a position which points me in the right direction.
With every project I will gain confidence but nevertheless frustration will be my good companion for quite some time.
Stick to the basics
and try to think the DAX way.
Obwohl ich nun schon wirklich lange möglichst viele Bereiche zum Thema Power BI verfolge, ist die DAX Sprache nach wie vor herausfordernd für mich. Wobei mittlerweile denke ich, das geht jedem so…
Daher habe ich als Auffrischung unlängst den Mastering DAX workshop der allseits bekannten SQLBI Helden besucht.
https://www.sqlbi.com/cert/yjlt1zzu-211003/
Ich habe nun den Vergleich zum ebenfalls angebotenen Online Course und einer Schulung in „echt“.
Ich muss sagen, da liegen wirklich Welten dazwischen. So viele Kleinigkeiten, die in DAX aber sehr große Auswirkungen haben, können einfach nur face to face bewusst gemacht werden.
Die für mich wichtigsten Erkenntnisse sind zwar nichts Neues, aber man muss sie diese egal auf welchem Level man sich in DAX bewegt immer wieder vor Auge führen:
Obey the rules
Es gibt zwar oft mehrere Wege, um eine DAX Formel zu erstellen, aber im Prinzip fast immer nur eine richtige Lösung.
(nothing else)
Heißt einfach übersetzt, stimmt das Ergebnis einer Formel nicht, ist zu 99,99 % das die Ursache des Problemes.
CALCULATE löst viele Probleme
Entscheidend dabei ist aber, das man sich immer wieder vor Augen hält, wann CALCULATE was macht, warum CALCULATE das macht und wann CALCULATE allenfalls gar nicht erforderlich ist.
NEVER filter a table, always filter fields
Selbsterklärend hier geht es vor allem um Performance
ERP and BI 