SQL Server Innovations

How To Extract data from Sharepoint Online using Power BI Code Snippet as below: let     Source = SharePoint.Files("https://XYZ.sharepoint.com/", [ApiVersion = 15]),     #"Sprint Backlog.xlsx_https://XYZ.sharepoint.com/Reporting  Forms/" = Source{[Name="Sprint Backlog.xlsx",#"Folder Path"="https://XYZ.sharepoint.com/Reporting  Forms/"]}[Content],     #"Imported Excel" = Excel.Workbook(#"Sprint Backlog.xlsx_https://XYZ.sharepoint.com/Reporting  Forms/")      in     #"Imported Excel"

How to Find a Value by searching Multiple Columns in  Power BI Problem: We were combining data from 2 source systems and transforming directly within Power BI and as a result, need to filter Contract Manager which can come from either system Approach: You can create derived column and use CONCATENATE DAX formula to get the value, DAX example as below and then you can use Text Filter - so it can filter in either column DerivedFiledName = CONCATENATE( 'DataSource 1'[DS1FieldName]   ,'DataSource2'[ DS2FieldName])