Forum Discussion
"Cannot connect to the mashup data source"
Hi , Anonymous
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
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Super UserHi Anonymous
When it is refreshing via the On-Premise Gateway, the error is saying that the table has no visible columns. If you can make sure that your table dim_profile is returning columns.
And also that the username and password being used via the ODBC in the Gateway can query the tables?