"Cannot connect to the mashup data source"

Question

Hi Everyone,&nbsp;I'm having trouble trying to refresh the data in power bi service. I'm trying to connect Athena database using ODBC connection.The ODBC connection have connected with no issues, however, when I try to refresh the data, I'm having this following error:But the data is being refresh on powerbi desktop with the ODBC connection not on service, any&nbsp;help would be appreciated as the error is not clear to me.&nbsp;Thank you.

v-yueyunzh-msft · Accepted Answer

Hi ,&nbsp;thumma&nbsp;
Based on the error message you provided, although you confirm that your local .pbix file can be refreshed normally, the refresh error still looks like a Power query problem: "the table has no visible columns and cannot be queried", if it is convenient for you to download this report as a .pbix file again and enter Power query to see if each query can load all the data normally.
Here are links to some related error cases:
The table has no visible columns and cannot be que... - Microsoft Power BI Community
apache spark - Querying Delta.io tables with Power BI returns the "The table has no visible columns" - Stack Overflow
&nbsp;
Best Regards,
Aniya Zhang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly

Forum Discussion

"Cannot connect to the mashup data source"

2 Replies

Related content

Enterprise gateway "cannot connect to the mashup data source"

Dataflow Gen2 cannot write to Fabric SQL Database, error says "Data source kind: FabricSql"

Data source error: Expression.Error: We cannot convert the value "[Table]" to type Table.. Microsoft

Snowflake connector: "We cannot convert the value null to type Text"

Scheduling Error: "cannot connect to the mashup data source"