"We reached the end of the buffer." on Importing or DirectQuery to Azure Data Explorer (ADX)

[Noureen]

Hey!

Here's what I have tried:

• I have an ADX cluster, Database and tables.
• On a new PBIX, I tried importing data using DirectQuery and Import mode using the PowerBI ADX connector
• Entered ADX cluster URI of the form https://<name>.<region>.kusto.windows.net
• Entered Database and table, limited query records to 10, 100 and so on.
• I tried adding every other option described on the Azure documentation.
• When I try to connect to this cluster, I get the below error:
• 
• I have scanned through every other community post and documentation on this error from ADX.
• Nothing to avail.
• Enabled Diagnostics and tracing but nothing logs on the ErrorsInfo.yaml file
• I replicated the same steps on a new cluster as well, nothing to avail.

What works:

• I am able to only connect to the help cluster provided by ADX

I am not able to navigate myself through the cause for this error. It would be absolutely helpful of you to guide me on where I am going wrong?

Does the cluster need any exclusive permission/access to query using Power BI? My user has full access to this cluster, database and tables.

Thanks in advance! 

[v-yangliu-msft]

Hi  @Noureen ,

This may be a memory issue. Please set aside enough memory to run Power BI, and try to reinstall the latest version of Power BI Desktop.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Try changing the maximum cache size in the options

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Noureen]

Hey!

I have the latest version of PBI Desktop installed and reinstalled it, in fact.

I updated the size limits to numbers suggested but they default back to these when saved:

After this process, I still encounter the same error as posted before:

"We reached the end of the buffer."

Is there any other workaround to this?

Would really appreciate your help in this!

[Noureen]

@v-henryk-mstf The three options mentioned on one of your solutions, with regards to Unable to connect to Azure Data explorer from Power BI Desktop do not work out for this issue. I have also tried to clear permissions and then reconnected. I was still not able to connect to the data source. Do you have any suggestions on how to tread further?