Anonymous's avatar
Anonymous
Not applicable
5 years ago
Status:
New

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

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

 

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

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

 

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

 

5 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support

    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's avatar
    Anonymous
    Not applicable

    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?