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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TheKnall
Frequent Visitor

Direct Query to Azure SQL DB, visuals throw Error code 8632.

Hi

Have a Direct query dataset connected to a Azure SQL DB. Have created some measures that  I want to display in the report.
Standard DAX functions work, but when I add iterrators like SUMX to a visual it throws an "Couldn't load the data for this visual'.

Details says: "The service has encountered an error processing your request. Please try again. Error code 8632."

anyone?

Thx

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @TheKnall ,

 

You could refer to this solved case which is similar to yours.

https://community.powerbi.com/t5/Desktop/DataSource-Error-Error-code-8632/m-p/113157

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
v-eachen-msft
Community Support
Community Support

Hi @TheKnall ,

 

You could refer to this solved case which is similar to yours.

https://community.powerbi.com/t5/Desktop/DataSource-Error-Error-code-8632/m-p/113157

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
JarroVGIT
Resident Rockstar
Resident Rockstar

Hi @TheKnall ,

DirectQuery knows quite a few limitations and unfortunately,  You can read more about limitations of DirectQuery here:

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery 

Is your measure returning more than a million rows somewhere in the process? 

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Azure SQL db running in S2 so it got Power.

ETL process is clean in PQ No extra steps.

The table has 3 rows and about 30 columns. So its a small table.

All agregations that does not iterrative like sum, count etc.. Works fast. Problems comes when adding aggs like sumx, then it throws the error.

Been Reading on the Subject and could be its running out of resources or the Query back to the db becomes to Long.

Anyone have had same issues?
Anonymous
Not applicable

We are using tabular model and we had this issue many times.

In our case when we add measure in table it throws same error...could not load visual...this one is because when there are other numerical columns which are summerized..so resolution is change numerical column to "don't summerize".


Still issue persist then you need to cross check on your measure dax .

Thanks
Pravin

If it resolves your problem mark it as a solution and give Kudos.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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