Tuesday – Power BI Technology and More
Every Tuesday, I look at a tech topic. This could be a new feature, how something works or how to troubleshoot something within Power BI technology, Reporting Services and Analysis Services.
This may also include the occasional topic relating to the Microsoft Data Platform as a whole, such as SQL Server or an Azure technology. Because of Power BI, there will also be content related to Office 365 and Azure Active Directory.
Mark as Date Table in Power BI Desktop is finally here! In this video, Patrick takes what Adam did with a custom date table and shows you how you can use Mark as Date Table [...]
In this video, Adam looks at how to create a Power BI date table using DAX. The end result uses a combination of the GENERATE(), ROW() and CALENDARAUTO() DAX functions to create a calculated table [...]
We look at a Power BI tutorial on how to properly complete the app registration within Azure Active Directory (AAD). This power bi tutorial is needed as we see many questions about the proper configuration [...]
In this video, Adam looks at data regions and how they work with Power BI, Azure Analysis Services, and the On-Premises Data Gateway. For the use of a single gateway, all services must be within [...]
In this video, Patrick shows you how you can easily use Azure SQL Database Failover Groups with Power BI to ensure you have access to your data. Connecting to an Azure SQL Database Failover Group [...]
In this video, Adam looks at how you can use Active Directory custom attributes for the user lookup with the Power BI Gateway. This can be used for both Analysis Services mapping and the Kerberos [...]