Forum Discussion
SharePoint online multiple lists power BI
Hi Anonymous,
If data structure of all the regions such as (Indonesia, Thailand, Singapore, Japan) are same, you can combine them into one.
Best Regards,
Angeliav-huizhn-msft thank you!
Microsoft EmployeeHi Anonymous,
Q: Is it possible to combine all these lists in a regional HR dashboard (specific regions) and Global dashboard (all regions)?
You means combine all the lists into one dataset? If it is, you can select all lists when you import data like the following screenshot.
Then you can combine all the table in Query Editor, you can review: Append vs. Merge in Power BI and Power Query. And there is a similar thread for your reference.
In addition, when you import all data, you want to restrict different HR's access to view data, you can use Row-level Security in Power BI. And I post some articles, you can review them.
Using Username() in DAX with Row-Level Security
Row Level Security in Power BI
Dynamic Row Level Security with Power BI Made Simple
Please feel free to ask if you have any other issues.
Best Regards,
Angelia
v-huizhn-msft and Angelia ..
many many thanks for this!!!
So I am able to company using links above ...
final question
Q: I will be using single data entry form for all the regions such as (Indonesia, Thailand, Singapore, Japan) and I will generate all the form data for all the regions from the that single data entry for Global HR.
Using links above can I achcive this?
Thank you!!
- v-huizhn-msft
Hi Anonymous,
If data structure of all the regions such as (Indonesia, Thailand, Singapore, Japan) are same, you can combine them into one.
Best Regards,
Angeliav-huizhn-msft thank you!