SharePoint Hosting Images for Power BI Dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-1692475%22%20slang%3D%22en-US%22%3ESharePoint%20Hosting%20Images%20for%20Power%20BI%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1692475%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20multiple%20paths%20to%20get%20this%20to%20work%20properly%2C%20and%20have%20come%20to%20a%20dead%20end.%26nbsp%3B%20Looking%20for%20some%20assistance%20on%20the%20best%20way%20to%20accomplish%20displaying%20images%20within%20a%20Power%20BI%20report%20using%20a%20SharePoint%20Image%20URL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20case%3A%3C%2FP%3E%3CP%3EI've%20got%20a%20survey%20tool%20that%20stores%20images%20and%20data%20to%20SharePoint%20Online.%26nbsp%3B%20There%20are%20several%20thousand%20photos%20in%20total.%26nbsp%3B%20I%20have%20built%20a%20dashboard%20to%20display%20the%20roll-up%20of%20the%20survey%20results%2C%20but%20need%20to%20drill%20down%20into%20the%20raw%20details%20of%20some%20surveys%20and%20view%20the%20photos.%26nbsp%3B%20I%20need%20this%20functionality%20for%20all%20users%20with%20access%20to%20the%20report.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrent%20state%3A%3C%2FP%3E%3CP%3EI%20have%20successfully%20pulled%20in%20the%20root%20folder%20information%2C%20and%20file%20extension%20for%20the%20photos%20into%20PBI%20Desktop%20(%3CA%20href%3D%22http%3A%2F%2Fname.sharepoint.com%2Fsites%2Fname%2Ffolder%2Fimage.jpg).%25C2%25A0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fname.sharepoint.com%2Fsites%2Fname%2Ffolder%2Fimage.jpg).%26nbsp%3B%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EIf%3CFONT%20size%3D%225%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CU%3E%3CSTRONG%3EI%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FFONT%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eam%20viewing%20the%20dashboard%2C%20all%20of%20the%20images%20are%20present.%26nbsp%3B%20(From%20reading%20on%20this%20forum%2C%20this%20is%20due%20to%20me%20having%20permissions%20to%20my%20folder%2C%20and%20thus%20I%20am%20authenticated%20vs.%20anyone%20else%20viewing%20who%20is%20not.)%26nbsp%3B%20If%20I%20share%20this%20dashboard%20with%20anyone%2C%20they%20are%20unable%20to%20view%20the%20photos.%20(however%20on%20a%20few%20occasions%20other%20users%20have%20been%20able%20to%20view%20these%20photos).%26nbsp%3B%20I%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CU%3EDO%3C%2FU%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ehave%20'Anyone%20with%20this%20link'%20permissions%20for%20the%20entire%20folder%20in%20which%20the%20photos%20are%20stored%20in%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20to%20solve%3A%3C%2FP%3E%3CP%3EDespite%20the%20folder%20being%20shared%20with%20'Anyone%20with%20this%20link'%2C%20I%20have%20tested%20the%20direct%20link%20used%20in%20BI%2C%20by%20sending%20to%20another%20user%2C%20and%20they%20are%20still%20asked%20to%20login.%26nbsp%3B%26nbsp%3B(%3CA%20href%3D%22http%3A%2F%2Fname.sharepoint.com%2Fsites%2Fname%2Ffolder%2Fimage.jpg)%25C2%25A0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fname.sharepoint.com%2Fsites%2Fname%2Ffolder%2Fimage.jpg)%26nbsp%3B%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EIs%20there%20a%20different%20'direct%20link'%20that%20can%20be%20used%20for%20the%20photos%20that%20is%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CU%3E%3CSTRONG%3ENOT%3C%2FSTRONG%3E%3C%2FU%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Emanually%20created%20by%20clicking%20the%20'share'%20link%20in%20SharePoint%3F%26nbsp%3B%20As%20there%20are%20several%20thousand%20photos%2C%20this%20is%20not%20scalable.%26nbsp%3B%20Or%20is%20there%20another%20workaround%20or%20process%20that%20could%20be%20used%20to%20display%20the%20photos%20using%20the%20SharePoint%20image%20URL%20in%20BI%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1692475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1738593%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Hosting%20Images%20for%20Power%20BI%20Dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1738593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801659%22%20target%3D%22_blank%22%3E%40BlueTech%3C%2FA%3EWe%20are%20having%20the%20exact%20same%20issue.%20It%20is%20rediculas%20that%20they%20make%20this%20process%20so%20complicated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%20that%20as%20long%20as%20everyone%20who%20is%20using%20the%20PowerBi%20dashboard%20has%20full%20access%20to%20the%20sharepoint%20site%20hosting%20the%20images%20it%20shouldnt%20be%20a%20problem%2C%20but%20we%20are%20yet%20to%20test%20that%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehopefully%20someone%20will%20come%20along%20with%20a%20solution%20soon.%20It%20would%20be%20great%20if%20Forms%20could%20translate%20the%20links%20into%20the%20sharable%20ones%20but%20this%20is%20microsoft%20we%20are%20talking%20about!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Greetings,

 

I've tried multiple paths to get this to work properly, and have come to a dead end.  Looking for some assistance on the best way to accomplish displaying images within a Power BI report using a SharePoint Image URL.

 

Use case:

I've got a survey tool that stores images and data to SharePoint Online.  There are several thousand photos in total.  I have built a dashboard to display the roll-up of the survey results, but need to drill down into the raw details of some surveys and view the photos.  I need this functionality for all users with access to the report.

 

Current state:

I have successfully pulled in the root folder information, and file extension for the photos into PBI Desktop (http://name.sharepoint.com/sites/name/folder/image.jpg).  If I am viewing the dashboard, all of the images are present.  (From reading on this forum, this is due to me having permissions to my folder, and thus I am authenticated vs. anyone else viewing who is not.)  If I share this dashboard with anyone, they are unable to view the photos. (however on a few occasions other users have been able to view these photos).  I DO have 'Anyone with this link' permissions for the entire folder in which the photos are stored in SharePoint.

 

Problem to solve:

Despite the folder being shared with 'Anyone with this link', I have tested the direct link used in BI, by sending to another user, and they are still asked to login.  (http://name.sharepoint.com/sites/name/folder/image.jpg)  Is there a different 'direct link' that can be used for the photos that is NOT manually created by clicking the 'share' link in SharePoint?  As there are several thousand photos, this is not scalable.  Or is there another workaround or process that could be used to display the photos using the SharePoint image URL in BI?

 

Thanks for the help

1 Reply
Highlighted

@BlueTechWe are having the exact same issue. It is rediculas that they make this process so complicated.

 

My question is that as long as everyone who is using the PowerBi dashboard has full access to the sharepoint site hosting the images it shouldnt be a problem, but we are yet to test that

 

hopefully someone will come along with a solution soon. It would be great if Forms could translate the links into the sharable ones but this is microsoft we are talking about!

 

Cheers