Moving From C/AL to AL

Veröffentlicht am von

Finally I was able to attend a two days online training in order to get a solid introduction into AL Programming.

I can highly recommend this course to any C/AL developer who want’s to get started with AL quickly.

The intend of this post is not to go into the details of this training. Rather I want to point out the my top take-aways:

1. Be prepared for the cloud (NAV BC SaaS). A lot if smart people mention this as the first rule whenever you have to make a decision.

2. Get yourself trained on the concept of Microservices as this is probably also a very good approach for extension design.

3. Learn about the Power Platform. The connection between NAV BC and the Power Platform is getting better and better. So you should at least consider using the Power Platform in certain cases.

4. Get familiar with Azure and Azure functions. My feeling is that you will need them more and more.

5. When redesigning any NAV C/AL solution in AL think not about coding challenges in the first place. Redesigning the solution is the real challenge.

6. Just because it is possible doesn’t mean you should do it.

 

 

Direct Query for Power BI (Preview)

Veröffentlicht am von

I like this explanation very much. Alberto Ferrari is really good at describing complex topics in an entertaining way. I see a lot of potential in this feature and not just for large enterprises.
I like the idea of keeping the data in the cloud and only enriching it with new data and measures. And the new concept of chaining datatasets is also very exciting.
And this is probably the first time I’ve heard anyone talk about DirectQuery without making a disgusted face.

DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI

New composite models in Power BI: A milestone in Business Intelligence – SQLBI

PowerApps – Manage Azure Resources

Veröffentlicht am von

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://www.bythedevs.com/post/manage-azure-virtual-machines-with-power-apps-and-azure-resource-manager

https://zimmergren.net/developing-with-azure-part-4-resource-explorer/

https://resources.azure.com/

BC Month End with Power Automate

Veröffentlicht am von

Josh Anglesea

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?:

  • User setup – change the allow from and…

Ursprünglichen Post anzeigen 847 weitere Wörter

Automatically refresh dataset when dataflow refresh completes — BI Polar

Veröffentlicht am von

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

Copy Report Layout between two PBIX files

Veröffentlicht am von

Rui Romano Blog - A place to share my thoughts

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:

  • Unzip the source and target PBIX files using a tool like 7zip

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