Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
BuragapuRitesh
New Member

facing an issue with building reports on my Power BI desktop with the help of data flow using direct

Hi everyone, I am facing an issue with building reports on my Power BI desktop with the help of data flow using direct query mode. In the Power BI Services, I have enabled compute engine settings" and also turned on the enabled compute engine for this dataflow so I can access it through direct query from the Power BI desktop. It seems that when I am loading the data flow in my power bi Desktop, it is loading fine, but when I am using any column from the data flow by the direct query method, I am facing an error: "An internal error happened due to a failed runtime assertion: failed to get cluster Uri status = unauthorized content = the exception was raised by the idbcommand interface." The dataflow is refreshingly fine in the Power BI service.
I have tried to clear cache from the power bi desktop as well but there is no solution.
ERROR 3 .png

 

.Storage mode is direct queryStorage mode is direct query

 

Getting errorGetting error

 

2 REPLIES 2
BuragapuRitesh
New Member

1. In which visual does this error happen? Does it happen in other visuals?

Ans: For every visual, it is happening. I have tried various visuals like line charts, bargraphs, etc., but the error pops out immediately when I insert the column from the table, which is in direct query to the value columns. 

 

2. Does this visual only have columns from the DirectQuery dataflow?

Ans: I just pulled one column, or if I pull any column, from the direct query table, and the error shows up, but I have tried with one table from direct query and one table from import, and both from direct query as well, and there is no change in the error; it continues, but if I take both tables from import mode, it works fine. 

 

3. If you create a new report with only this dataflow in DirectQuery mode as the data source, will this error happen?

Ans: Yes, I am building the report with the data flow as the data source in direct query mode. When I load the table from PowerBI Services to PowerBI Desktop, it loads well, but when I pull the values, an error shows up.

 

4. If you create another dataflow and allow it to be connected in DirectQuery mode, will this error happen?

Ans: Yes, I have tried with various data flows as well. I have created new data flows with less data to see if the error occurs or not, and yes, with the other data flows that are in direct query mode, the error shows up.

 

5. What is the Power BI Desktop version?

Ans: Currently, I am using 2.123.742.0 32-bit (November, 2023)
version.png

 

 

 

 

 

 


  

Anonymous
Not applicable

Hi @BuragapuRitesh 

 

I don't find a known issue regarding this currently. Can you provide more details regarding this error?

1. In which visual does this error happen? Does it happen in other visuals?

2. Does this visual only have columns from the DirectQuery dataflow?

3. If creating a new report with only this dataflow in DirectQuery mode as the data source, will this error happen?

4. If creating another dataflow and allows it to be connected in DirectQuery mode, will this error happen?

5. What is the Power BI Desktop version?

 

Best Regards,
Jing

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.