Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Remove excel export with live connection format

Since recently (today?) the export options have changed for the reports on power bi service. Currently when a user exports the data from a chart the default file format is set to Excel with live conn...
Need Help
ibarrau's avatar
ibarrau
Super User
3 years ago

Hi. That's a new option that has been released to get more rows. If you want to export the way it was before just open de dropdownlist and change it

 

For now the default option shown is the live connection. I don't think you can change it, but you can try removing the options of analyze excel or excel live connection from the tenant settings and check if that removes it.

I hope that helps,

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks a lot for your quick reply! Where can I find the tenant settings to remove the analyze in excel or excel live connection options?

    • d4t0r's avatar
      d4t0r
      Regular Visitor
      3 years ago

      Hi Martine2607, 

      did you find a way to get rid of 500k option ? 

       

      BR

      • dbexpress108's avatar
        dbexpress108
        Regular Visitor
        2 years ago

        Hi d4t0r,

         

        I had this exact issue and managed to turn off the Excel live connection by turning off the following option in tenant settings:

         

        Users can work with semantic models in Excel using a live connection
        Disabled for the entire organization
        Users can export data to Excel from a report visual or semantic model, or export a semantic model to an Excel workbook with Analyze in Excel, both options with a live connection to the XMLA endpoint.