unable to update BI dashboard when using SharePoint

[SharonLei]

Hi, 

I am the creator of a BI report. I would like to share the report to other team members so they can view and update data in the report. I use the SharePoint as a data source but got this message 'Authorisation aren't specified'.

Any suggestion on how to solve or allow other members to update the data in the report?

Many Thanks,

[v-zhangti]

Hi, @SharonLei 

For reports with the data source as SharePoint, connect and refresh, please refer to the following link.

Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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

[SharonLei]

Hi, 

Thanks for your reply.

The origanial data files were stored in my oneDrive when I created the BI report. But now I want to change the data source to SharePoint and move the files to SharePoint in a subfolder called 'Rec report' in a folder "document". 

What can I do in order to allow my team members to update the data via SharePoint? Or is there other soluntions?

Thanks, 

Sharon

[StefanoGrimaldi]

yes sure give them access as you do in a onedrive file and they will be able to modify work on the file also from sharepoint can be done as onedrive to syn files to your pc: 

https://support.microsoft.com/en-us/office/sync-sharepoint-files-with-the-onedrive-sync-client-groov... 

[StefanoGrimaldi]

try giving access only to the root of the sharepoint tenant, not the entire direction, this helps woth diferente credentials problems and updates you can encounter.