Forum Discussion
Powerbi reports
Hi bzeeblitz Could you follow these please
Load Data:
- Import Report1 (Excel with counts) and Report2 (SharePoint list).
Transform Data:
- Ensure Date columns match format.
Merge Queries:
- Use Power Query to merge datasets on Date (Left Outer Join).
Add Measures:
- Total PO Number:
COUNTROWS('Report2')- New Count:
SUM('Report1'[CountColumn])- Completed:
COUNTROWS(FILTER('Report2', [Status] = "Completed"))- No Action:
COUNTROWS(FILTER('Report2', [Status] = "NoAction"))Build Report:
Create a table visual with Date, Total PONumber, New Count, Completed, and No Action.
Refresh:
- Schedule data refresh for Excel and SharePoint in Power BI Service.
Hi bzeeblitz Could you follow these please
Load Data:
- Import Report1 (Excel with counts) and Report2 (SharePoint list).
Transform Data:
- Ensure Date columns match format.
Merge Queries:
- Use Power Query to merge datasets on Date (Left Outer Join).
Add Measures:
- Total PO Number:
COUNTROWS('Report2')
- New Count:
SUM('Report1'[CountColumn])
- Completed:
COUNTROWS(FILTER('Report2', [Status] = "Completed"))
- No Action:
COUNTROWS(FILTER('Report2', [Status] = "NoAction"))
Build Report:
Create a table visual with Date, Total PONumber, New Count, Completed, and No Action.
Refresh:
- Schedule data refresh for Excel and SharePoint in Power BI Service.
I already developed report for report1 which is fetching data from multiple tabls from excel which was stored in SharePoint folder and next SharePoint list I added into the same power bi existing report so sharepoint list data is stored as table and visualization I'm trying to do for this SharePoint list data so now I'm creating measure for complete but I'm getting error fetching data for this visual. Kindly help