Exporting data to Excel with current layout
I am using Power BI report Server and it is absolutely crucial for my client to export data with current layout to excel. Some tables use hirarchy and thus usual export doesnt produce the result I am looking for. Is there a way to export data from power bi report server with current layout. If not what workaround can I use? Can I do it from Power BI Desktop (Not service, just desktop)?Allow data export only for certain users
Hello all, I don't think so, but I prefer to ask the question anyway. Is it possible to allow data export (SSRS reports and PowerBI Dashboards) only for certain users? For the others, it would have to be blocked. Thank you in advance for your feedback, Have a nice day, Vivien
Where is the export "Underlying data" option in Report Server?
We are using Power BI Desktop (October 2017) optimized for Report Server. We recently migrated from PBI Service to PBI Report Server. There appears to be a different set of "Export data" capabilities between Power BI Service (cloud) and Power BI Report Server (on-premises). The option to select either "Summarized data" or "Underlying data" is not showing in Power BI Report Server as it does in Power BI Service. This missing capability is now a problem for our reports users because when they select "Export data" it goes immediately to Save or Open. If it is a simple table, the data they receive from the export is only that simple table and not the underlying detailed data. Not useful. Is the "Summarized data" / "Underlying data" capability missing from Report Server or is there some configuration setting we need to enable? Thanks for any help!
