topic Re: Do not have permission to export underlying data in Report Server

Do not have permission to export underlying data

Anonymous — Mon, 12 Nov 2018 15:56:12 GMT

I created a dataset in PowerBI Desktop which consists of 9 queries to a SQL Server using DirectQuery and the 9 queries are connected with each other. I published the dataset to PowerBI Web for others in my organization to create reports using these queries. Currently, some of the reports allow me to export underlying data while others say I do not have permission to export underlying data. I am also the owner of the workspace I am working in and have powerbi admin rights.

Re: Do not have permission to export underlying data

Greg_Deckler — Mon, 12 Nov 2018 16:31:35 GMT

Are the ones where you can export also DirectQuery or import?

Re: Do not have permission to export underlying data

Anonymous — Mon, 12 Nov 2018 17:03:04 GMT

All the reports are DirectQuery

Re: Do not have permission to export underlying data

Anonymous — Mon, 12 Nov 2018 17:13:50 GMT

The ones I can export are also DirectQuery

Re: Do not have permission to export underlying data

Anonymous — Mon, 12 Nov 2018 17:37:35 GMT

All the reports are using a dataset with DirectQuery

Re: Do not have permission to export underlying data

Anonymous — Mon, 12 Nov 2018 18:19:22 GMT

The ones I can export are also DirectQuery

Re: Do not have permission to export underlying data

morph268 — Tue, 04 Dec 2018 00:59:25 GMT

Do you have the export setting turned off for the report?

https://community.powerbi.com/t5/Service/Prevent-export-underlying-data/m-p/534014/highlight/true#M54907