Schlagwort: Power BI

Power BI RLS from SharePoint column

März 18, 2023 / Marvin Bangert / Keine Kommentare

Hi folks,

Sometimes you get data not from a database, but as a file like CSV and you need to visualize it in Power BI, but not giving access to the data for everyone. And worse, the people are not mentioned in the file itself. Today I will show you how you can control access to a specific file using SharePoint and Row Level Security (RLS) in Power BI. This trick only works if your users User Principal Name (UPN) is the same as the email. Let’s start.

Power BI: Divison wanted – my German ‚Bezirksliga‘ suggestion

Juni 26, 2022 / Marvin Bangert / Keine Kommentare

Hey folks,

if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.

Power BI Azure AD Error – Power BI App Permission required

Dezember 9, 2021 / Marvin Bangert / Keine Kommentare

Hey folks,

today I came across a problem on a customer site within Power BI when trying to update an App and giving access to other users within a workspace. I want to share the solution with you, hope it will help you.

#MSIgnite – Power Platform Updates

März 4, 2021 / Marvin Bangert / Keine Kommentare

Am Dienstag, 02.03.2021, um 17:30 Uhr CET ist die #MSIgnite 2021 mit der Keynote von Microsoft CEO Satya Nadella gestartet. Zuerst stellte Satya fünf Schlüsselattribute der nächsten Generation von Cloudinnovationen vor:

Ubiquitous and decentralized computing
Sovereign data and ambient intelligence
Empowered creators and communities everywhere
Economic opportunity for the global workforce
Trust by design

Neue PowerShell cmdlets für Data Gateway Installation (Public Preview)

Mai 7, 2020 / Marvin Bangert / Keine Kommentare

Am 06. Mai 2020 wurde über den Power BI Blog die Public Preview für die Automatisierung des Data Gateway angekündigt. Dabei wurden neue PowerShell cmdlets angekündigt, die die Automatisierung des Data Gateway Connectors ermöglichen.

Power BI: SharePoint Online Datum und Uhrzeit korrigieren

März 13, 2020 / Marvin Bangert / Keine Kommentare

Wer in Power BI Daten aus SharePoint Online eingebunden hat und dabei vom UTC Datumsformat abweicht, ist sicherlich schon auf das Problem gestoßen, dass das Datum und die Uhrzeit in Power BI nicht richtig ist. In diesem Beitrag zeige ich, wie ihr den Fehler beheben könnt.