Importing photos in PowerBI from Fulcrum App?

[OVRanger]

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?

[v-rzhou-msft · Accepted solution]

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.

[OVRanger · Accepted solution]

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.

[v-rzhou-msft · Accepted solution]

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.