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 →
(Copied from: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2019-feature-summary/) Our August release has another hotly anticipated feature from the Microsoft Business Application Summit, grouping. Grouping in reports, similar to PowerPoint’s grouping, lets you easily organize groups of visuals to move and resize them as a set. This month’s release also has some updates to our newest features, such as an icon … Read More →
(Copied from: https://powerbi.microsoft.com/nl-nl/blog/announcing-the-new-filter-experience-for-power-bi-reports/) The wait is over! This month we are incredibly excited to announce that the new filter experience is now generally available! We have updated the look and feel and added a ton of new functionality. Let’s walk through what’s included in the new filter experience! Pop-up Filter List With the new filter … Read More →
(Copied from: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/) With this month comes the first feature release from our announcements at Microsoft Business Application Summit, Icon sets, which also addresses our current #1 idea on ideas.powerbi.com. On top of this major update, we have incremental improvements for many of our existing features, such as a counts experience for the Key influencers … Read More →
Please have a look at this article from Brian Meier: https://cloudblogs.microsoft.com/dynamics365/it/2019/07/17/power-bi-apps-for-dynamics-365-business-central-and-dynamics-nav/ Starting September 1, 2019, content packs are no longer supported on Power BI online. Because of that, updates are no longer supported, and these content packs have been removed from powerbi.com and replaced with Power BI apps. The Power BI apps are now available in Microsoft AppSource and … Read More →