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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.