Power Pivot : Sql query in the connection properties is greyed out. RRS feed

  • Question

  • The SQL query in the command text of the connection properties in the power pivot report is greyed out along with the edit query button.The report is connected to a SQL server and i believe an exel service analysis cubes embedded in exel. How can i access the query ? 
    Sunday, February 17, 2019 7:19 PM

All replies

  • If by "PowerPivot Report" you have a PivotTable connected to Analysis Services cube, then it's normal for this property to be greyed out as there will not be a SQL query. PivotTables against cubes generate dynamic MDX queries on the fly, not SQL. If the cube is based on data in a SQL server there are typically multiple SQL queries used to load the different objects in the cube. But you need admin rights to be able to access these queries, but even that might not be much help as you'd need to manually figure re-create all the joins and calculations.

    http://darren.gosbell.com - please mark correct answers

    Sunday, February 17, 2019 8:01 PM