cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OVRanger
New Member

Importing photos in PowerBI from Fulcrum App?

Hello. Does anyone have any experience with importing photos from a Fulcrum App into PowerBI? I have no problem bringing data across from Fulcrum Apps to PowerBI and working with that data.

I can import the photos and can see the URL's in my tables, but I can't get the images to display at all - they just show the generic image icon. (I've changed the categorisation to image URL). I have tried importing the photos from Fulcrum using both data shares and direct queries, but both methods only end up displying the image icon, not the image.

Any ideas?

2 ACCEPTED SOLUTIONS
RicoZhou
Community Support
Community Support

Hi @OVRanger 

How did you connect to Fulcrum App to get photo, Web or Query API?

For reference: Connecting to Power BI

Both of them need you to authenticate to get access to data source.

Please check if you have authenticated correctly when you connect to Fulcrum App. Make sure the account you have authenticated has access to the photo url.

Normally, the images will show broken in desktop and will work well in Power BI Service. Please publish your report to Service and check your photos.

I think the steps are like getting image from sharepoint. You may refer to the video as below.

For reference: How to Display SharePoint Images to 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.

View solution in original post

OVRanger
New Member

Thank you Rico

It’s working now. The last sticking point was the File Origin type in Power BI- by default it came in as Windows and I needed to change that to 65001: Unicode (UTF-8). That tip was on the info you sent through, so thanks very much.

FYI – the photos only work using query functions, not Fulcrum data shares. The issue was that when using photo_url from the data share link, it provided the fulcrum photo viewer url, not the actual photo url. The query function provides the actual photo url.

Also, my photos are displaying in PowerBI Desktop which is handy.

View solution in original post

2 REPLIES 2
OVRanger
New Member

Thank you Rico

It’s working now. The last sticking point was the File Origin type in Power BI- by default it came in as Windows and I needed to change that to 65001: Unicode (UTF-8). That tip was on the info you sent through, so thanks very much.

FYI – the photos only work using query functions, not Fulcrum data shares. The issue was that when using photo_url from the data share link, it provided the fulcrum photo viewer url, not the actual photo url. The query function provides the actual photo url.

Also, my photos are displaying in PowerBI Desktop which is handy.

View solution in original post

RicoZhou
Community Support
Community Support

Hi @OVRanger 

How did you connect to Fulcrum App to get photo, Web or Query API?

For reference: Connecting to Power BI

Both of them need you to authenticate to get access to data source.

Please check if you have authenticated correctly when you connect to Fulcrum App. Make sure the account you have authenticated has access to the photo url.

Normally, the images will show broken in desktop and will work well in Power BI Service. Please publish your report to Service and check your photos.

I think the steps are like getting image from sharepoint. You may refer to the video as below.

For reference: How to Display SharePoint Images to 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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.