How can I allow the user with “view” access to export whole source data stored in sheets from a Bar Chart? If they export now it only gives them the values presented in the chart.
This is the output from Chart
This is the Source data in gsheet
How can I allow the user with “view” access to export whole source data stored in sheets from a Bar Chart? If they export now it only gives them the values presented in the chart.
This is the output from Chart
This is the Source data in gsheet
Hi @Kumar1987 , thanks for your post!
A user with “View” access to a report in Looker Studio can only access what is on the chart itself, and not the datasource. What you could do is share a reusable data source for users to be able to build reports on and query in Looker Studio, you can definitely do that - that way they can build their own reports and query the data in the way that they need. The instructions for sharing a reusable data source are on the Share reusable data sources documentation page here: https://support.google.com/looker-studio/answer/10403278
I hope that is helpful!