Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Team,
I am unable to connect sharepoint folder / sharepoint online lists from powerbi desktop. I am currently using power bi pro july edition. i set the credential as organisation in data source settings for sharepoint kindly help on this. So that i can setup auto refresh using flow / api call. PFA of errors which am facing. FYI I am having owner permission for OSDOperation in teams.
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi @Anonymous ,
@AllisonKennedy is right you have to use the Organization Account connection method.
In your screenshot you only change the privacy level of the data.
I think the next problem will be the correct URL of the SharePoint site.
Here you will find an illustrated guide.
https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/
Hi @Anonymous ,
Based on my test, it does not have to be the owner of the folder. Just need to have read permission.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please let us know if the methods above are helpful.
Best Regards,
Icey
Hi @Anonymous ,
@AllisonKennedy is right you have to use the Organization Account connection method.
In your screenshot you only change the privacy level of the data.
I think the next problem will be the correct URL of the SharePoint site.
Here you will find an illustrated guide.
https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/
Thanks mate, I succeed - login to SharePoint folder through PowerBI.
To access SharePoint folder/list, and to create flow for automate is it mandatory to being Owner of that folder ?
Hi @Anonymous ,
Based on my test, it does not have to be the owner of the folder. Just need to have read permission.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |