Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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.
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.
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |