Drill through a table row via a hyperlink rather than relying on hidden right click functionality
It is not possible to click on a table row and directly drill through to a destination. Instead, a user must right click on a row, select drill through, and then select the destination page. This is not ideal for 2 reasons 1. The user doesn't know that drill-through is even a possibility. There...
Data Mart Dataset not visible in XMLA Workspace Endpoint
I created a DataMart a few days ago which has data for it. When I open the XMLA endpoint for the workspace in SSMS, I can see other datasets but not the dataset created by the data mart.
Ideally, each dataset would have its own XMLA endpoint (rather than one per workspace) a...
BUG: Data Marts - Power Query does not work when connected to an enterprise gateway
I have a data mart connected to a SQL Server via an enterprise gateway. The data mart is able to retrieve data from the gateway (it can be refreshed without issue) but Power Query isn't able to connect to the source, so no Power Query activities can be accomplished (e.g. renaming a data set, ...