Dynamics User Group
Site
Search
User
Site
Search
User
Dynamics 365 Business Central/NAV User Group
think about IT
Forums
Blogs
Resources
Wikis
Events
Leaderboards
Members
Mentions
Tags
More
Cancel
New
Dynamics 365 Business Central/NAV User Group requires membership for participation - click to join (it's free)
think about IT
Blog by NAV MVP Steven Renders
Home
Subscribe by email
More
Cancel
Posts RSS
Atom
More
Cancel
Monthly archive list
January 2021
(1)
September 2020
(1)
June 2020
(2)
May 2020
(12)
April 2020
(4)
March 2020
(2)
February 2020
(6)
December 2019
(3)
November 2019
(7)
October 2019
(3)
September 2019
(1)
August 2019
(1)
July 2019
(8)
June 2019
(2)
May 2019
(4)
April 2019
(4)
March 2019
(4)
February 2019
(8)
January 2019
(14)
December 2018
(11)
November 2018
(16)
October 2018
(8)
September 2018
(10)
August 2018
(2)
July 2018
(10)
June 2018
(6)
May 2018
(4)
March 2018
(14)
February 2018
(6)
January 2018
(2)
December 2017
(12)
November 2017
(6)
October 2017
(8)
September 2017
(10)
August 2017
(4)
July 2017
(8)
June 2017
(2)
March 2017
(4)
February 2017
(10)
January 2017
(10)
December 2016
(8)
November 2016
(7)
October 2016
(4)
August 2016
(2)
July 2016
(3)
May 2016
(2)
April 2016
(1)
March 2016
(3)
February 2016
(1)
January 2016
(4)
December 2015
(4)
November 2015
(2)
October 2015
(4)
September 2015
(2)
August 2015
(2)
July 2015
(2)
June 2015
(4)
May 2015
(3)
April 2015
(1)
March 2015
(2)
February 2015
(1)
October 2014
(1)
April 2014
(2)
December 2013
(2)
April 2013
(4)
December 2012
(5)
November 2012
(2)
October 2012
(2)
September 2012
(2)
July 2012
(4)
June 2012
(6)
May 2012
(4)
April 2012
(2)
March 2012
(10)
February 2012
(4)
January 2012
(4)
December 2011
(2)
November 2011
(2)
October 2011
(2)
Related
Related Tags
blog
dynamics 365 business central
Dynamics NAV
Dynamics NAV 2009
Dynamics NAV 2013
Dynamics NAV 2016
Dynamics NAV 2017
Dynamics NAV 2018
Dynamics365
Event
Hans Rosling
Homepage
How To
NAV 2009
NAV 2013
NAV 2015
NAV 2016
Power BI
Quick Tip
RDLC
SQL Server
Blog post list
Tags
Subscribe by email
More
Cancel
By date
By view count
By comment count
Descending
Ascending
Quick Tip: Interesting aka.ms links for Business Central
Steven Renders
Here are some interesting aka.ms links I have found: aka.ms/bcideas Dynamics 365 Application Ideas for Dynamics 365 Business Central aka.ms/bccountries Country/Regional availability and Supported Translations aka.ms/collaborate Microsoft Collaborate aka.ms/readytogo The “Ready to Go” Program aka.ms/bclearn Microsoft Learn for Business Central aka.ms/bcproductivity Working with Business Central aka.ms/bckeys Keyboard Shortcuts aka.ms/bcupdates Major Updates of Business Central Online aka.ms/bclastminorupdate …
2020-2-26
Mirror post
dynamics 365 business central
Quick Tip
408 views
0 comments
10 months ago
More
Cancel
Quick Tip: Create your preview environments for Business Central 2020 release wave 1
Steven Renders
Try out the new Business Central 2020 release wave 1 functionality today! Learn how to prepare for major updates with preview environments: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/preview-environments Are you interested to test out all the new bells and whistles of BC version 16, then create your preview sandbox as follows. Go to your Business Central Admin Center: Then spin up a new sandbox: Click Yes: Wait a little bit… And voila… Provide feedback on the preview Browse to aka.ms/collaborate If you have not…
2020-2-22
Mirror post
dynamics 365 business central
Quick Tip
How To
493 views
0 comments
11 months ago
More
Cancel
Power BI Desktop February 2020 is out and Incremental refresh is now generally available!
Steven Renders
Microsoft has announced the release of Power BI Desktop: February 2020 and you can read all about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/ I am very happy about incremental refresh, which is now generally available and is now supported for Power BI Pro licensing, meaning it is no longer a Premium only feature! Read all about that here: Incremental refresh is now generally available This is extremely important for all SMB companies who for example are using Dynamics 365 Business Central as a data source for Power BI, because…
2020-2-19
Mirror post
Power BI
669 views
0 comments
11 months ago
More
Cancel
How Do I: Add a Drill-Through to See Records in Power BI Desktop?
Steven Renders
Imagine you have created an amazing Power BI report that summarizes information using different visuals. Power BI Desktop lets you build advanced queries, models, and reports that visualize data and the idea is that the individual records that come from your data source are aggregated and summarized in your report, giving you the possibility to see the big picture. Let’s look at an example, where we import information from the GL Entries table in Business Central: Here I created a matrix that displays general ledger amounts by account category, subcategory and name. And as you expect you…
2020-2-13
Mirror post
dynamics 365 business central
Power BI
How To
598 views
0 comments
11 months ago
More
Cancel
How Do I: Create a Report based upon a Query?
Steven Renders
Performance wise it can be very interesting to use query objects as a data-source in a report (or any other object). Imagine you want to create a report that shows the top X records from a table, let’s say for example Customers, then creating a report dataset with a top-x filtering can be very cumbersome. An example is available in report 111 Customer – Top 10 List. Here you see that in order to calculate the top 10 customers, you first need to loop over all customers, then store the top 10 records in a temp table and then loop over the temp table to add its records to the dataset. Imho that…
2020-2-10
Mirror post
RDLC
dynamics 365 business central
How To
421 views
0 comments
11 months ago
More
Cancel
How Do I: Implement an Incremental Refresh in Power BI (Free or Pro)?
Steven Renders
A question I get a lot in my Power BI training for Business Central, and non Business Central companies is the following: How can I implement an incremental refresh, without building a data warehouse and without buying a Power BI Premium license? And to be honest, the answer is, it’s not really possible, but there’s a workaround. The workaround is an incremental refresh, using a cutoff-date, but this date might need to be manually updated at a certain moment. Let me explain how this works. But before I do that, I should also mention that last week I was enormously pleasantly surprised…
2020-2-2
Mirror post
dynamics 365 business central
blog
Power BI
How To
572 views
0 comments
11 months ago
More
Cancel