In Power BI Desktop, and in the Power BI Service, Maps and Filled Map visuals might show up as follows: Don’t worry, there’s nothing wrong with your report, it’s a new setting, announced in October last year. Back in October, we announced that we were introducing a tenant-level setting to enable or disable Bing Maps … Read More →
In almost every PowerBI report at some point you will require time intelligence. You might want to display information on a timeline or create time based measures using DAX time intelligence functions. For that to work properly it’s a best practice to always create your own Date (or Calendar) table in the Power BI … Read More →
In this post I will demonstrate how you can create simple APIs of type Query and Page to be used in Power BI. The idea is to have a look at an example where we create 2 very simple APIs: a Customers Query and a Customers Page. In VSCode, create a new project using AL:Go! and … Read More →
DynamicsCon March 2022 is a FREE, 3 day virtual learning experience for 8,500+ Microsoft Business Application users and professionals. You will be immersed in programming covering Power Platform, Dynamics GP, and Dynamics 365 products: Business Central, Customer Engagement, Finance & Operations. Have a look at the agenda: Agenda – DynamicsCon And… I’m also speaking: … Read More →
Dou need to create Power BI reports for Business Central Saas that require data from one or multiple companies from your tenant, then you can use this template: blog/MultiEnvironment at master · srenders/blog (github.com) When you run the pbit file (template), you are asked to login with your office 365 BC credentials: Next a … Read More →
It’s been a while since I posted, and I have a lot of posts coming about Business Central and Power BI, but I wanted to put your attention first on some idea’s that I created. Let’s have a look at these ideas: Add Business Central as a Data Source in DataFlows Enable incremental refresh for … Read More →
Recently Microsoft added the Table Information page to Business Central. See here. And underlying are these objects: Table Information (8700, List) Table Information (2000000028) So I was thinking, hey let’s use this in Power BI. Then my first thought was to create a query object using the Table Information table as a data item, but … Read More →
Recently Renato Fajdiga and I were asked to do a webinar about Power BI and Business Central. In Microsoft Dynamics 365 Business Central, we have a more intuitive and faster way to create new Power BI reports that you can share with other users in Business Central. In this webinar, you will learn how to … Read More →
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: … Read More →
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 … Read More →
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 … Read More →
I recently came across a question in the Business Central forum: How do I get information about Posted Sales Shipments in Power BI? And this is not a standalone question, I get these questions a lot in my training’s that I deliver all over the world. Many times I see answers suggesting to use existing … Read More →
Imagine you have created a Power BI report and you want to display in in the Customer list. Then you need to add a report filter in the Power BI report, before you publish it to your work space: Then in Business Central you can go to the customer list page and in the Power … Read More →
When you use the Power BI Desktop connector for Business Central: you will see all your environments (production, sandboxes,…): And if you try this in the latest version, with the new look & feel, you will see something like this: Nice to see an idea implemented ! 😎https://t.co/W1AO5qrZMI #msdyn365bc #PowerBI pic.twitter.com/YSCNKTFBUu — Steven Renders (@srenders) … Read More →
(Copied from: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2019-feature-summary) You’ll notice one of our exciting updates right away when creating new reports with the September update of Power BI Desktop, a new, modern default theme! Not only do we have a new default theme, but we’ve more than doubled the number of built-in theme options for your report. If you’re a … Read More →