I have the following query which accesses an on-premise instance of SSAS through a gateway:
let
Source = AnalysisServices.Database
(
"MyServer", "MyDB",
[
Query= "EVALUATE
(
SummarizeColumns(Geography[TimeZone], Geography[Area])
)",
Implementation="2.0"
]
)
in
Source
When I put this query in a PBI Dataset and publish to the service, it retrieves data from SSAS. (The Dataset needs to be configured with the gateway mappings, but after that can be refreshed without issue).
When I put the same query in a Dataflow, I couldn't get the connection working.
- Is this a valid thing to do?
- What is wrong with the below:
Here's what I did:
- Created a dataflow
- Created a blank query and pasted in the above query
On the page where I pasted in the query, the "Data gateway" selector indicated the correct gateway
- Pressed "Next" on the dialog
- Got a message: "we could not evaluate this query due to missing or invalid credentials"
- Pressed "Configure connection"
- The Connect to data source dialog was displayed,
Only option was to "Create a new connection"
The suggested connection name was "MyServer;MyDB"
(the correct gateway was shown)
I entered Windows Credentials
Note: was not possible to enter Organizational creds ... the creds box was not displayed (flickered/vanished)
- Pressed "Connect"
- Got a message: "the connection you are trying to use has not been shared with you on the data gateway"
Additional:
- Went to Manage Connections and Gateways
Could see the gateway/connection I wanted: ("MyServer_MyDB") and Gateway Cluster Name was correct for this
Could see the gateway/connection I had created: ("MyServer;MyDB) and Gateway Cluster Name was "(personal mode)"
- I retraced the above steps and entered "MyServer_MyDB" for the connection name, but this didn't have any different result
- I clicked on the settings for the connection I wanted: ("MyServer_MyDB") and the settings were displayed with the following banner:
This connection is read only because you do not have gateway admin or connection owner permissions for this connection
Shouldn't it be possible to have the Dataflow use the connection that works for the Dataset as a simple (mapping) config??
