Get URL for issue attachment using powerBI

edgar.chan6WJ3M
Contributor
Contributor

Get URL for issue attachment using powerBI

edgar.chan6WJ3M
Contributor
Contributor

Hi

I am trying to get of photo attachment in issue by getting the link in URL using the data from data connect through powerBI. Although I am still exploring ways, is there a easy way to get it?

Reply
594 Views
3 Replies
Replies (3)

Thomas_Ball7KW99
Community Visitor
Community Visitor

I would like to be able to do this as well, have a clickable link from PBI to open attachment from issue in browser. Surely the URL can be constructed by concatenating the info

0 Likes

s.iwasakiSYTFM
Enthusiast
Enthusiast

URLcreate.pngFirst, the photos on ACC have the following URL structure.
This is an example in the table "photos_photos".
https://acc.autodesk.com/build/photos/projects/ bim360_project_id /photos/uid

If such URL information is available in the data downloaded from the Data Connector, it can be used as is.
To create a URL like the above in PowerBI, use the "New columu" function.
The URL can be automatically obtained by writing the following script.

 

 

URL = "https://acc.autodesk.com/build/photos/projects/" & [bim360_project_id] & "/photos/" & [uid]

 

You found a post helpful? Then feel free to give likes to these posts!
Please click the Accept Solution button if my reply answers your question.
こちらの投稿は役に立ちましたか?良ければ「いいね」お願い致します!
こちらの投稿があなたの問題解決に寄与した場合、「解決策として承認」ボタンのクリックへのご協力をお願い致します。

Satoshi Iwasaki
ONESTRUCTION Inc.
0 Likes

unitedhomeservices90
Community Visitor
Community Visitor

To get the URL for issue attachments in PowerBI, you can use the BIM 360 API to pull issue data, including attachment links. Once the data is imported, you can set up a custom column in PowerBI to extract air duct cleaning Plano and display the attachment URLs for easy access.

 

0 Likes