This article helps you understand what people can do with the reports and data sources you share with them. It also explains the difference between access permissions (who can view/edit the report or data source) and data credentials (who can see the actual data). Access permissions determine what people can do with
a Looker Studio asset: Edit access to a data source lets users modify its schema. They can
add or change calculated fields, disable and enable fields, and change data types and field aggregations (when permitted by the data source). For both reports and data sources, you can restrict sharing, downloading, and copying of the files. Permissions don't control who can actually see the data. That is governed by data credentials. The table below shows what you can do with reports using the different access permissions. "Public" means the report has been shared with view access, and the link sharing option "Anyone with the link can view" or "Public on the web." Data source access detailsThis table shows what you can do with data sources using the different access permissions. Data sources can't be shared using public link sharing.
Data credentialsData credentials determine who can see the data provided by a data source:
Sharing a report or data source doesn't change the credentials used. Learn more about controlling access to data. Was this helpful? How can we improve it? Why is my access report not displaying data?An Access report will display whatever is in its Recordsource (subject to a filter). If the Recordsource changes the report will reflect those changes. So if a report is not displaying data you think it should be the first place to look is to see whether its being returned in the Recordsource. Hope this helps, Scott<> P.S.
What can you do with reports in access?Overview of reports in Access What can you do with a report? A report is a database object that comes in handy when you want to present the information in your database for any of the following uses: Display or distribute a summary of data.
What can you do with Microsoft Access?Once your data is in Access, you can add more tables and join them, create queries (or views of your data), structure the data and define data types to help ensure data integrity, share and update data among many users, and create powerful reports and forms.
How do I access data access governance reports?In the left pane, select Reports > Data access governance. The following reports are currently available: The Sharing links reports help you identify potential oversharing by seeing the sites where users created the most new sharing links. A report is available for the following links:
What are the limitations of Access?This article has information about the limits of Microsoft Access database files and objects.
...
Query.. Can an Access report pull from multiple queries?The reports you provide can be a lot more detailed and informative if they contain results of multiple queries. There is no uniformity required, while putting multiple queries in a report. You can select whichever query you like, and they can all be unrelated, it will not impact the results.
Can we modify data using an Access report?No, this is because we don't modify data using an access report.
What can you not import from one Access database into another Access database?The file format can be either MDB or ACCDB. If the file is in MDE or ACCDE format, you'll only be able to import tables and queries from other Access databases. You can't import forms, reports, macros, and modules into an MDE or ACCDE file.
|