In this example we are going to hard code everything. Store configuration data such as Tenant Id in the spreadsheet.Is not completely clear about, and the inspiration for me learning Power Add some new columns to tell us quickly if a row is a Regular user,ī2B user, Local B2C or Federated B2C. ![]() Render some lists as semi-colon delimited.We are going to do a lot in future articles, but these are things you might be chomping at the bit to do. I pick columns that are superfluous to me ![]() Hide some superfluous columns with the Advanced Query Editor.Identify our domain’s tenant id via both the Azure Portal and AzureRM.Install Power Query if we are running an older version of Excel. ![]() We are going to accomplish the following: If something doesn’t work quite right on another version of Excel, leave a note in the comments. The screenshots in this article were taking using Excel 2016 on Windows 10 with an Office 365 Business subscription. As its the first article besides the introduction it assumes zero knowledge of Power Query. This article is part of a series on Using Power Query For Excel as an Azure AD Dashboard.
0 Comments
Leave a Reply. |