CODEWITHSUNDEEP
google-cloud-platformpowerbipowerbi-desktopgoogle-cloud-storage
Naveen
Naveen

Reputation: 465

Powerbi report to download file from Google cloud storage

I want to use PowerBI dashboard to show a Bigquery table and links with Google storage objects as downloadable files.

The table in BigQuery contains the links of the object stored in Google cloud bucket and can show it as a link in the dashboard. When I click the link it takes me to web browser and using my single signon it is download the file. However, the person who clicks the link should have access to the bucket and all files underneath.

Is there a way to restrict access to Google cloud storage and allow the person to download object from the Powerbi dashboard?

Thanks

Upvotes: 0

Views: 309

Answers (1)

Sathi Aiswarya
Sathi Aiswarya

Reputation: 2940

You can achieve this by generating signed URLs,Signed URLs can have a time limit associated with them. In your application you would create a signed url for the file and do a HTTP redirect to said file. You can refer to this document

A signed URL is a URL that provides limited permission and time to make a request. Signed URLs contain authentication information in their query string, allowing users without credentials to perform specific actions on a resource. When you generate a signed URL, you specify a user or service account which must have sufficient permission to make the request that the signed URL will make. After you generate a signed URL, anyone who possesses it can use the signed URL to perform specified actions, such as reading an object, within a specified period of time.The most common uses for signed URLs are uploads and downloads, because in such requests, object data moves between requesters and Cloud Storage.

Upvotes: 0

Related Questions