Forum Discussion
Auto-refreshing failed due to DM_GWPipeline_Gateway_MashupDataAccessError
Hi all,
I'm sturggling with this one. Occationally one of my reports will constantly fail the auto-refresh feature (I'm importing data) due to a data mashup error. From what I can see, some of the reports use a data mashup, but others just query the database. I'm usuing a odbc connector to a Impala (cloudera) DB. When I go to look up recent queries I find the following:
Sql Statement: USE `MicrosoftDataMashup(string of hex values which I've deleted)`
Is there a way to disable the data mashup and just query the db?
Any help will be greatly appreciated.
2 Replies
v-xicaiCommunity Support
Hi alpacaMan ,
There are several points you may considerate:
1.Please check if you have right connect credential, pay attention to connect steps :Connect Microsoft Power BI desktop to Cloudera Impala or Hive with Kerberos.
2.Please check all the 32bit or 64bit versions. First check if Power BI is 32bit or 64bit by going to File->Accounts. Then the downloaded Cloudera ODBC DSN has to match 32bit or 64bit same as Power BI.
3.Upgrade the data gateway to latest version, and then try it again.
For reference:
Unable to Connect Power BI to Impala connector
Troubleshooting refresh scenarios
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.