Hi,
I have a workbook with a connection to a cube in an SQL Analysis Server (a .odc file). I have created a pivot table based on this connection.
I have created another query in Power Query (a select * from a table in a SQL Server) and I want to relate this query to the cube and embed it to the pivot table. But the name of the query is not shown together with the cube data (facts and dimensions).
I created another worksheet and I made a new pivot table based on the second query (from Power Query). This pivot table shows, of course, the connection of Power Query but doesn't show the connection with the cube data.
How can I have both connections together and interrelate them?
Thank you.
I have a workbook with a connection to a cube in an SQL Analysis Server (a .odc file). I have created a pivot table based on this connection.
I have created another query in Power Query (a select * from a table in a SQL Server) and I want to relate this query to the cube and embed it to the pivot table. But the name of the query is not shown together with the cube data (facts and dimensions).
I created another worksheet and I made a new pivot table based on the second query (from Power Query). This pivot table shows, of course, the connection of Power Query but doesn't show the connection with the cube data.
How can I have both connections together and interrelate them?
Thank you.