ISSUE::DIRECTQUERY::ANALYSIS SERVICES::LAKEHOUSE TABLE

[Element115]

PBI Desktop Version: 2.128.1380.0 64-bit (April 2024)

Selecting this datasource like so:

and clicking on the first Connect:

which results in this:

Why then do I get these error messages???  

[amitchandak]

@Element115 , please refresh the semantic model on power bi service and try again.

Or check which table us causing that issue.

Create a copy of that table with full data, delete the data from that table, and reload it from backup. refresh sematic model and try

For Lakehouse you might have to use Spark to do this

[Element115]

I really don't understand... there is no semantic model in Fabric.  Only tables in the LH to which PBID connects in DirectQuery mode.  When doing so using the SQL endpoint, there are no issues, therefore it is not the LH tables that are the problem.  And when connecting via DirectQuery to Analysis Services of the same LH, that's when this issue pops up.

Therefore everything points towards a PBID connector problem.