Dynamics 365 Business Central: How to import Advanced Evaluation Data (EXTENDED Package – Complete Sample Data)

Today I would like to discuss the sample data of Business Central Cloud (SaaS).
As you might know, when creating a new company in Business Central, you can select the data and setup to get started if you need to test data.

Source : Dynamics 365 Lab
Read more…

Delaying Power BI Dataset Refresh Until The Source Data Is Ready

This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so the old data was being loaded by mistake. The best solution here is to use some kind of external service (for example Power Automate) to poll the data source regularly to see if it’s ready, and then to refresh the dataset via the Power BI REST API when it is.

Source : Chris Webb’s BI Blog
Read more…

Analyze data using Query Analyzer in Business Central

Inline Query Analyzer is a tool to analyze data in Business Central. This is an open source project intended to help developers for quick retrieval of data for analysis purposes. You can write SQL like queries to retrieve data. Users can view the query results in Grid and JSON views.

Source : msnJournals
Read more…