Dataflow Refresh Error: ODBC: ERROR [HY000] Showing a modal dialog box or form

[LukeMcManagan]

I'm getting the following error when refreshing dataflows in PBI Service:

Error: ODBC: ERROR [HY000] Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.

Here are some details on the dataflow

• The datasource is a CDATA Salesforce ODBC connection on our enterprise gateway
• The dataflow contains multiple Salesforce tables/object queries
• Sometimes the dataflow refreshes successfully
• The error appears on different queries on each refresh (so it's not a specific query causing the issue)

I've searched around for the past 2 days for resolutions to this but the fixes all seem related to web development making them useless - none associated with PowerBI.

Can anyone please shed some light on what might be causing the issue?

[LukeMcManagan · Accepted solution]

Finally found the cause of this issue.

The issue was related to the ODBC driver showing a “invalid http response! firewall” popup error on two of the nodes/servers in our gateway cluster. This was due to incorrect proxy details on both nodes despite a successful connection test when the source was initially set up.

The issue effected different entities/dataflows due to the fact the proxy details were incorrect on 2 out of 10 available nodes.

[LukeMcManagan]

Thank you very much for your response Eyelyn!

Where would I configure that call? Would it be a setting on the ODBC connection?

[v-eqin-msft]

Hi @LukeMcManagan ,

Sorry for not helping you in time. In fact, I couldn't reproduce it until now. As I suggested before, you could create support ticket for more professional help.

Apologize for the inconvenience again.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @LukeMcManagan ,

It seems like you forgot somewhere a MessageBox.Show call that doesn't work on a real web server (it is server side code and so tries to show a message directly on the web server rather than on the client side).

Hope this help

https://community.powerbi.com/t5/Developer/Power-BI-System-InvalidOperationException-Showing-a-modal...

In addition, I suggest you go to https://support.powerbi.com ,scroll down and click "CREATE SUPPORT TICKET" for further help.

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