Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Direct query issue after upgrading to gateway (September 2021 release)

Submitted by Anonymous on ‎09-21-2021 01:40 PM

Hello

After completing an upgrade to the September 2021 powerBI gateway our reports using direct query have begun to fail. Any tips please.

 

Fig1 you can see in powerBI desktop the data is returned

ncarrier08_0-1632256644955.png

 

Fig2 you can see the datasource attached to the gateway sucessfully refreshed

ncarrier08_2-1632256728380.png

Fig3 you cannot see the visual and the error message is not helpful!

ncarrier08_3-1632256766232.png

 

Am I missing something obvious here the goal is to connect to an on premise SQL box, produce a report, upload to BI and have the gateway provide a direct query to the dataset. 

 

This all worked on the only Sept 2020 version....

 

Any assistance appreciated.

 

Thank you

 

Status: New
See more ideas labeled with:
5 Comments (5 New)
Comments
v-robertq-msft
Community Support
Community Support
‎09-21-2021 07:43 PM

Hi, 

I suggest you to go to the dataset setting page and check if the gateway is online and the data source is correctly configured:

You can refer to this link:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

Anonymous
Not applicable
‎09-22-2021 01:10 AM

Everything is green and connected from the gateways point of view. As I said in the screenshot the refresh appears to be happening without error just the visuals are failing.

 

 

v-robertq-msft
Community Support
Community Support
‎09-22-2021 07:39 PM

Hi, 

Would you like to create a new workspace and publish this report from the Power BI desktop again and configure the gateway and dataset credential again to check if the visual can correctly display.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Anonymous
Not applicable
‎09-23-2021 05:16 AM

Tried that.

 

It works fine in PowerBI desktop, the gatway seems to refresh but then looking at the report the visuals do not disaply as per fig3

 

Any other suggestions?

v-robertq-msft
Community Support
Community Support
‎09-24-2021 01:05 AM

Hi, 

If you want to get a solution for this kind of visual rendering problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses