Autor: selfservicebi
-
Importing model.json to create a new dataflow — BI Polar
If you’re a frequent reader of this blog, or a frequent user of Power BI dataflows, you probably know these things already: Power BI dataflows are workspace-level objects in the Power BI service that enable data reuse through self-service data preparation. Power BI dataflows store data in the CDM folder format in Azure storage. CDM […]…
-
Governing Power BI just got a little easier — BI Polar
The reaction to this recent post on lineage and Power BI dataflows highlighted how important lineage is for Power BI[1]. Although (as this post shows) there are lineage user experiences in place for dataflows today, and experiences coming for all artifacts in a workspace. Even with these new experiences, there will still be times when […]…
-
SSRS Reporting
Diese Seite finde ich empfehlenswert, geht zwar vorrangig um SSRS aber sind auch Tipps zum Dynamics NAV enthalten: https://reportsyouneed.com/category/ssrs/ Vor alllem die Aussage, die Aufbereitung der Daten mittels SQL, Views oder procedures möglichst in der Datenbank zu behalten, würde ich in meinen Szenarien unterschreiben. Im Optimalfall sollte das Reportingtool lediglich für die Visualisierung zuständig sein.…
-
Creating Updateable Power BI Reports with PowerApps by Ike Ellis — Sterlings
When asked what content our blog readers and video viewers would like to see more of, the most requested topic is: „Industry Best Practices“. With that in mind we will be starting a series of Blog posts and Webinars by our MVPs highlighting work they have done. The first in this series is by Ike […]…
-
Power BI Ecosystem Report Authoring Tools Demystified — Business Intelligence Insights
There are a lot of discussions these days around Power BI tools to create reports and for sure many of you may have already downloaded and worked with some of them if not all of them. You may also already thought that some of the tools’ names are confusingly similar. I recently had an interesting… über…
-
Do Data Types Matter in Power Query? — The Excelguru Blog
One of the things that I find a bit misunderstood in Power Query is whether or not Data Types matter. I mean, I’m sure everyone agrees to some point that they do, but you do know just how much they matter, and why? Over the weekend, I received an email from one of our loyal… über…
-
Date and Time Table M Scripts
Sehr gut, mit diesen Scripts lassen sich DateDim und TimeDim Entities leicht erstellen. Besonders gut gefällt mir der Ansatz, das durch einen Scheduled Refresh im Dataflow das CurrentDate automatisch aktualisiert wird. „Setting up a daily refresh schedule for this DataFlow will keep the flag values current, too (i.e. [Current Day?] and [Completed Day])“ Date and…
-
Power BI Project Good and Best Practices — Paul Turley’s SQL Server BI Blog
The purpose of this article is to outline a set of guidelines and recommended practices for managing Microsoft Power BI projects. This guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Again, this guide is primarily focused on the work performed by the IT-managed BI Solution…
ERP and BI 