flip-it.de :: SQL, BI and more

Main menu

Skip to content
  • Datenschutzerklärung
  • Me, myself and I
  • Impressum

Extract numbers from strings by using PowerQuery

22. Februar 2023

A customer told me, that he have a system with polls which collects numbers and strings as an answer. The result looks like these: Now, he wants to summarize the numbers and also to show the written answers. Next, I … Continue reading →

Posted in Allgemein

Process Event Hub data with Stream Analysis and push them into a dimensional model

5. Januar 2023

In my scenario, I get 1000 JSON files per day, which must be analyzed with Power BI. So, I will get approx. 380 million rows per year. The system has an initial load of circa. 500 Mio. rows. So, I … Continue reading →

Posted in Allgemein

Dashboards, DirectQuery and what you should know about refreshing

2. Januar 2023

A colleague said to me, that we can create a live dashboard in Power BI which displays actual data from database. I said NO! This post will show you, what you can do to achieve this goal. I’ve created a … Continue reading →

Posted in Allgemein

Query Power BI datasets to send an individual alert

10. Dezember 2022

When you configure a data alter inside a Power BI dashboard, you cannot configure another email address or modify the text inside the email. Another problem is when you want to inform another user. So, here you can use Power … Continue reading →

Posted in Allgemein

Change the data source from a local directory to OneDrive inside Power BI

19. November 2022

In the past, some customers asked me, how can I change the path for a local, imported file, to a path which can be refreshed by Power BI Online. You have two options, you can install a Power BI Data … Continue reading →

Posted in Allgemein

Power BI composite models – a underestimated feature

8. Oktober 2022

Power BI composite models are not really new, but in my point of view, a really underestimated feature and in my experience, not really often used. Let’s assume, you have two different departments, and every department creates its own models … Continue reading →

Posted in Allgemein

Post navigation

← Older posts

SQL Saturday 2019 Rhineland

Link

Neueste Beiträge

  • Extract numbers from strings by using PowerQuery
  • Process Event Hub data with Stream Analysis and push them into a dimensional model
  • Dashboards, DirectQuery and what you should know about refreshing
  • Query Power BI datasets to send an individual alert
  • Change the data source from a local directory to OneDrive inside Power BI

Kategorien

2008 R2 Allgemein BI BIDS Cluster Data Tools Data Warehousing Datenbanken Denali Disaster Recovery ETL Filestream Governance Installation Integrations Services Office 365 Partitionierung Performance Power Automate PowerBI PowerPivot PowerQuery PowerView Programmierung Reporting Services Sicherheit Spiegelung SQL Server Translation Tutorial VB.NET 2010 Verschlüsselung Visual Studio Volltext Vorträge Webseite Zertifikate

Blogroll

  • Deutsche SQL Server Blog

Links :: Etc.

  • Donkarls Access Seiten / Konferenzen
  • Power BI UG
  • Power BI UG Köln
  • SQL CAT
  • SQL FAQ
  • SQL PASS Mittelrhein

Links :: Legacy

  • Blättern mit PHP 4 & MySQL
  • ISO / OSI Schichtenmodell
  • Medienmanipulation
  • Online Subnetzrechner

Links :: Zur Person

  • XING Profil

Archive

  • Februar 2023
  • Januar 2023
  • Dezember 2022
  • November 2022
  • Oktober 2022
  • September 2022
  • August 2022
  • Juli 2022
  • Juni 2022
  • Mai 2022
  • April 2022
  • März 2022
  • Januar 2022
  • Dezember 2021
  • November 2021
  • September 2021
  • August 2021
  • Juli 2021
  • Juni 2021
  • Mai 2021
  • April 2021
  • März 2021
  • Februar 2021
  • Januar 2021
  • Dezember 2020
  • November 2020
  • August 2020
  • Juni 2020
  • Dezember 2019
  • Mai 2019
  • Februar 2019
  • Dezember 2018
  • November 2018
  • Oktober 2018
  • August 2018
  • Juli 2018
  • November 2017
  • September 2016
  • Februar 2016
  • November 2015
  • Juli 2015
  • April 2015
  • September 2014
  • August 2014
  • Juli 2014
  • Juni 2014
  • Mai 2014
  • Februar 2014
  • Januar 2014
  • Dezember 2013
  • November 2013
  • Oktober 2013
  • August 2013
  • Juli 2013
  • April 2013
  • Januar 2013
  • Dezember 2012
  • November 2012
  • November 2011
  • Oktober 2011
  • September 2011
  • August 2011
  • Juni 2011
  • April 2011
  • März 2011
  • Februar 2011
  • Januar 2011
  • Mai 2009

Neueste Beiträge

  • Extract numbers from strings by using PowerQuery
  • Process Event Hub data with Stream Analysis and push them into a dimensional model
  • Dashboards, DirectQuery and what you should know about refreshing
  • Query Power BI datasets to send an individual alert
  • Change the data source from a local directory to OneDrive inside Power BI
  • Power BI composite models – a underestimated feature
  • Use a key column for grouping in Power BI Desktop
  • Power BI and Visio
  • Overview of the Power BI Datahub        
  • Setup Purview to get Metadata from Power BI

Archive

  • Februar 2023 (1)
  • Januar 2023 (2)
  • Dezember 2022 (1)
  • November 2022 (1)
  • Oktober 2022 (1)
  • September 2022 (1)
  • August 2022 (1)
  • Juli 2022 (2)
  • Juni 2022 (5)
  • Mai 2022 (1)
  • April 2022 (3)
  • März 2022 (3)
  • Januar 2022 (3)
  • Dezember 2021 (4)
  • November 2021 (1)
  • September 2021 (2)
  • August 2021 (2)
  • Juli 2021 (1)
  • Juni 2021 (3)
  • Mai 2021 (2)
  • April 2021 (2)
  • März 2021 (3)
  • Februar 2021 (5)
  • Januar 2021 (5)
  • Dezember 2020 (6)
  • November 2020 (1)
  • August 2020 (1)
  • Juni 2020 (1)
  • Dezember 2019 (2)
  • Mai 2019 (1)
  • Februar 2019 (2)
  • Dezember 2018 (1)
  • November 2018 (1)
  • Oktober 2018 (2)
  • August 2018 (3)
  • Juli 2018 (1)
  • November 2017 (1)
  • September 2016 (1)
  • Februar 2016 (2)
  • November 2015 (1)
  • Juli 2015 (2)
  • April 2015 (2)
  • September 2014 (1)
  • August 2014 (4)
  • Juli 2014 (2)
  • Juni 2014 (3)
  • Mai 2014 (2)
  • Februar 2014 (1)
  • Januar 2014 (1)
  • Dezember 2013 (1)
  • November 2013 (1)
  • Oktober 2013 (2)
  • August 2013 (1)
  • Juli 2013 (2)
  • April 2013 (2)
  • Januar 2013 (2)
  • Dezember 2012 (1)
  • November 2012 (4)
  • November 2011 (3)
  • Oktober 2011 (1)
  • September 2011 (2)
  • August 2011 (1)
  • Juni 2011 (3)
  • April 2011 (4)
  • März 2011 (5)
  • Februar 2011 (2)
  • Januar 2011 (2)
  • Mai 2009 (1)

Kategorien

  • 2008 R2 (11)
  • Allgemein (94)
  • BI (26)
  • BIDS (4)
  • Cluster (1)
  • Data Tools (5)
  • Data Warehousing (2)
  • Datenbanken (6)
  • Denali (1)
  • Disaster Recovery (1)
  • ETL (5)
  • Filestream (1)
  • Governance (1)
  • Installation (2)
  • Integrations Services (1)
  • Office 365 (3)
  • Partitionierung (4)
  • Performance (2)
  • Power Automate (1)
  • PowerBI (15)
  • PowerPivot (14)
  • PowerQuery (4)
  • PowerView (1)
  • Programmierung (13)
  • Reporting Services (6)
  • Sicherheit (6)
  • Spiegelung (1)
  • SQL Server (31)
  • Translation (1)
  • Tutorial (4)
  • VB.NET 2010 (1)
  • Verschlüsselung (2)
  • Visual Studio (1)
  • Volltext (1)
  • Vorträge (5)
  • Webseite (1)
  • Zertifikate (2)
Powered by WordPress and Foghorn