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

Main menu

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

Monthly Archives: Februar 2021

Run an Azure Automation runbook with PowerShell to get data from the Power BI REST API

25. Februar 2021

Unfortunately, it is not possible to make a login to Power BI with the Cmdlet’s (Login-PowerBIServiceAccount) by Azure Automation. So, you cannot use the Power BI PowerShell commands to get very easy the requested information. But if you want to … Continue reading →

Posted in Allgemein

Orchestrate schedule refreshes in Power BI

22. Februar 2021

In my last Blog Post I showed you, how you can get every scheduled refresh of your Power BI tenant to organize them better and to avoid the eviction when you refresh too many datasets at the same time: https://www.flip-design.de/?p=921To … Continue reading →

Posted in Allgemein

Organize and monitor the Power BI scheduled refreshes.

13. Februar 2021

With Power BI you can set up a scheduled refresh of any dataset which have an accessible data source. But you must be aware of, how many refreshes are at the same time. With every particular capacity you have only … Continue reading →

Posted in Allgemein

Analyze the Power BI Activity Logs

8. Februar 2021

To get insights into your activities of Power BI from your users you have multiple options:– The Usage Metrics– The Audit Logs– … and the Activity Logs For me fits the last one, because you do not need an Exchange … Continue reading →

Posted in Allgemein

Translation of your Power BI Embedded Report (App owns data)

7. Februar 2021

If you use a Power BI Embedded Application (App owns data), the App runs in an English environment. But if your users need another language, you must enable the translation.Okay, the following report is deployed on the Power BI tenant: … Continue reading →

Posted in Allgemein

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