Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unable to Load Data with Downloaded Report from Service

Hello,

I am trying to update an existing report by adding new measures. The report was not created by me, but I have Admin access to the workspace and I downloaded the PBIX file.

The data model for this report is using a mixed model with DQ and Import methods. The DQ tables are not loading for me. FYI These tables are from an Apache Spark cluster.

I don't understand how my co-worker (who also owns the dataset in PBI Service) is able to download the PBIX file and have their data loaded. I have ensured that the cluster name and database is correct and that the appropriate credentials are entered, but I keep getting the error below:

Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct."
Can someone please help me troubleshoot?