Autor: selfservicebi
-
Build asymmetrical Pivot table in PowerBI — Project Controls blog
I have been asked to produce a simple construction report, we need to show the last 4 weeks of actual progress data and 6 weeks of forecast and to make thing a little bit complex the average installation since the start of the project, nothing special three measures, average to date, install per week and […]…
-
Constructing a datetime from an integer date and an integer time.
über Constructing a datetime from an integer date and an integer time.
-
Dies und das schnell notiert
Aufgrund der Urlaubszeit und sonstigen Verpflichtungen hier schnell ein paar Links für meine Sammlung: PBI incremental refresh My Preferences for SSIS Design – Data Savvy Microsoft Edge Insider Power BI: Gateway Monitoring & Administrating How to handle changes in NAV/BC when event does not exist ?
-
Free sample Power BI paginated report – Ultimate Export Report available for download
Ursprünglich veröffentlicht auf Christopher Finlan: I recently came across an interesting article on MSSQLTips for SQL Server Reporting Services that showed how you could use a T-SQL query as the parameter value, and have it return a table of data as the result set from that query. (The original article is here, and I will…
-
Setup Database Mail — SQL Server Science
SQL Server includes a great feature known as Database Mail. This post provides a quick script showing how to setup Database Mail without requiring you to click through a cumbersome user interface. The first part of the script needs to be customized by you so emails will be sent to the correct address. The Fair……
-
Dynamic Date Matrix
Wow, diese Time Matrix Tabelle sieht mal sehr gut aus. Wie im Beitrag erwähnt würde man solche Szenarien wohl eher mit Time-intelligence functions lösen, mir jedoch gefällt dieser klassische Ansatz sehr gut. Ok die DAX-Formeln sind jetzt nicht gerade sehr einfach nachzuvollziehen oder gar selber zu erstellen, aber dafür hat man ja solche Refernzartikel gespeichert,…
-
Sharing Data Between Organisations With Azure Data Share — Chris Webb’s BI Blog
If you’ve ever built a BI solution it’s likely you will have had to integrate third party data, and if that’s the case you will know how painful it often is to get your hands on that data. Badly designed portals you have to log into every week to download the data, CSV files emailed […]…
-
7 options to store data in Azure with Microsoft Flow
über 7 options to store data in Azure with Microsoft Flow
-
Drillthrough from Power BI to an SSRS Paginated Report
Paul Turley's SQL Server BI Blog Navigating from a Power BI report to an SSRS Paginated report with filters and parameters. Product VersionsSSRS/Paginated Reports (one of the following): – SQL Server Reporting Services 2016 or newer– Power BI Report Server– Paginated Reports in the Power BI service Power BI Desktop:– Power BI Desktop May 2019…
-
Power BI Report Builder for non-Premium datasets
Das ist wirklich groß. Jetzt können Reports auch ohne Premium Abo im Report Builder erstellt werden. Und wenn dann hoffentlich bald eine Veröffentlichung im Power BI möglich sein wird, dann ist das wirklich eine runde Sache. SSRS watch out, Winter is coming … Offizieller Link von Microsoft: Announcing support for non-Premium Power BI datasets in…
ERP and BI 