2020 – Page 54 – Pardaan.com

Refresh a Power BI dataset that feeds from SharePoint list automatically

The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and dataset that fully rely on SharePoint lists. These lists are used by business groups that don’t have the rights to spin…

24 January 2020

Dynamics NAV & BC Tips & tricks

Having Demo Data while developing Business Central Apps with Docker

I have always preached that you shouldn’t try to keep your Docker containers running. Containers should be something, which easily can be dismissed and recreated for any developer. One of the frequent questions is then: But what about my demo/development data? Source : Freddys blog Read…

23 January 2020

Dynamics NAV & BC Tips & tricks

Interface with Power Automate – is it really so easy?

During NAV TechDays 2019 there were a lot of sessions that I would describe as “develop Business Central doing minimum development using AL“. Sounds weird? For me yes… at least at the beginning. Speakers, such as Arend-Jan Kauffmann (https://www.youtube.com/watch?v=cp848e9WBFs), showed how to connect Business Central with…

22 January 2020

Dynamics NAV & BC Tips & tricks

Executing your .exe tasks on a Cloud environment by using Azure Functions

I think that many of you on your Dynamics NAV or Dynamics 365 Business Central projects have tasks executed by using console applications (.exe) scheduled by using Windows Task Scheduler or other systems. This works good for on-premise environments (just take your .exe application, create a…

21 January 2020

Data & Analysis

Power BI Dataset Refresh Scheduling Using Outlook And Power Automate

When the new “Refresh a dataset” action for Power Automate (formerly Flow) was released last year I couldn’t help thinking there must be something really cool you could do with it – I just didn’t know what. Source : Chris Webb's BI Blog Read more...

20 January 2020

Dynamics NAV & BC Tips & tricks

Putting Queries to Use in Business Central

We’ve had query objects for a while now – since NAV 2013 (I think). In theory they sound great, link a bunch of tables together, aggregate some columns, get distinct values, left join, right join, cross join – executed as a single SQL query. Source :…

17 January 2020

Dynamics NAV & BC Tips & tricks

Why and how to rename all AL-files of your app with the “CRS AL Language Extension”

So now – “let’s get started” with .. Why would I rename all my AL-files? Well – because of Microsoft and their new (upcoming) code analysis rule about file name conventions. You might already have complied with their previous conventions, and … they will change. Even…

16 January 2020