What connector do you use in Power BI Desktop, sharepoint folder or web?
I use web connector to connect to an excel file of a sharepoint online folder in the Desktop, create report. Then share the sharepoint folder to my colleague and send the PBIX file to her, she can refresh data in the PBIX file after enter her credential for the data source.
However, if you create report using SharePoint Folder connector in Power BI Desktop, it is not possible for your colleague to refresh the PBIX file as it requires the colleague to have permission on the root SharePoint site, but the colleague only have permission on the folder but not the root site. When using web connector, the issue doesn't occur because we can choose URL of the Excel file URL in "Select which level to apply these settings to" dropdown, and the colleague has sufficient permission on this level.
Community Support Team _ Lydia Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.