Forum Discussion
Need to create report using the data from multiple SharePoint Lists in Single Row
Hi I want to create the report using power BI. The report should be created using the data from multiple sharepoint lists. Please find the lists and data relations between these lists. DeptID is re...
Hi nileshwh
How did you create the lists in sharepoint? there is a specific way to do it.
If the files are already in excel, why don't you pout them in a folder and use Sharepoint Folder to improt them inot Power bi desktop. the rest is easy
Hi Amine,
Ther SharePoint lists have been already created and crud operations get performed using powerApps. Now I want to generate Power BI report to display the data spead in diffferent SP list in single row deptwise. The report data I want to import in excel file with download functionality. But the biggest challenge I am facing is displaying the employee details and Location details in single row in different columns for each department (As shown in screenshots).