Forum Discussion
Images stored on SharePoint broken image icon
Hi KarlOnEarth
I have a test to get image from sharepoint in Power BI.
Firstly get data by Sharepoint Folder connector in Power BI Desktop.
Here we need Sharepoint site url.
https://****.sharepoint.com/sites/***/
Then transform the Table in Power Query Editor, we need to add a custom column as below. This column is image url we need.
Click apply and change column categroy to image url in column tool.
Result is as below.
Power BI Desktop will show broken.
Power BI Service will work well.
Video: https://www.youtube.com/watch?v=tsQM8MKxxcc
Please check whether your Power BI account have access to your sharepoint. Here I use same account in sharepoint and in Power BI.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thank you for your detailed repsonse. I did exactly as you suggested. But when I check in the service, after I have published the model, the images are still broken:
If I copy one of the URLs out of the desktop model and paste it into my web browser, I'm logged in to sharepoint with the same user as my Power BI user, I see the image in my browser which seems to indicate that the user has access to the images.
Do you have any other suggestions as to what I can check?
And in fact, if in the browser, I right-click on the broken image icon and choose Open in another tab, the image opens in another tab and I can see it fine. That just seems to indicate that permissions is not the problem no?