Questions about connectivity between data source and report

Hi TermsOfService5 ,

1. If your users using the shared dashboard, a Power BI Pro or Premium license is required. If you have set RLS in the report and the users dont have access or have no data about them in the report, the dashboard they used will show blank. About dashboad, you can refer this document: Dashboards for Power BI service consumers 
2. The visualizations on a dashboard come from reports and each report is based on one dataset. The dataset is based on the datasource to model of the report.
3. To refresh data source, you can choose refresh on demand or configure scheduled refresh for it. For on-premiss data source, you need a gateway to configure scheduled refresh. For web data source like sharepoint, just grant credentials instead of using gateways. This document can help you understand it better in details about data refresh in power bi service.
4. When you publish reports to power bi service, if you are a Pro user, you can publish it to Myworkspace and Appworkspaces(classic workspace and new workspace); if you are only the free user, you can only publish it to Myworkspace. In addition, any changes you make to the report in Power BI won't be saved back to the original Power BI Desktop file. When you change the contents of the report, you need to re-publish the report to power bi service. You can refer this document: Publish datasets and reports from Power BI Desktop 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.