The table no visible columns and cannot be queried

The error message "The table has no visible columns and cannot be queried" typically indicates that the table that you are trying to query in your report does not have any visible columns. This could happen for a variety of reasons, such as:

• The table has been filtered to the point where no columns are visible.
• The table has been hidden or deleted in the report.
• The data source has changed or been updated, causing the table structure to change.

Here are some steps you can try to resolve the issue:

1. Double-check that the table is visible in the report. Open the report in Power BI Desktop and make sure that the table is visible in the Fields pane. If it is not visible, try adding it back to the report.

2. Check the filters in the report. If you have applied filters to the report, make sure that the filters are not hiding the columns in the table. You can try removing the filters to see if the columns become visible.

3. Check the data source. If the data source has changed or been updated, the table structure may have changed, causing the columns to be hidden. Try refreshing the data source to see if the columns become visible.

4. Check the report settings in the Power BI service. Open the report in the Power BI service and check the report settings. Make sure that the table is visible in the report and that it has not been deleted or hidden.