Failed to use the selected gateway error after updating to latest Personal gateway

[Kit]

Dear Support,

Updated to the latest personal gateway recently, and broke all of my dashboard refreshes.

Tried uninstall/reinstall the personal gateway to no avail. Have confirmed that the gateway is online in the PowerBI Data(Preview) page. Nothing fancy in the data model, just an SQL connection, error message from PowerBI refresh below.

Activity ID: e23f36f4-8ca0-49a4-b0c0-58bfd6ed7c94
Request ID: 38ae190c-6dd3-8dd5-35bf-a03278c6d14e
Correlation ID: 2f7dda74-7783-ddce-cf30-8eadd0d7e84b
Status code: 400
Time: Wed Mar 20 2024 11:36:36 GMT+0800 (Singapore Standard Time)
Service version: 13.0.22924.53
Client version: 2403.3.18499-train
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net/

[FarhanAhmed]

Do you able to see your gateway from PBI Service online ?

[Kit]

Yes I see the gateway from PBI Service Online, and it says its online. Sharing screenshots of various pages below

[Kit · Accepted solution]

Found the problem, its not a gateway issue.

There was a new table loaded into the dashboard as DirectQuery, while all previous tables were loaded as Import. Found this when i clicked through each table in the pbix file and got the warning that this one file was imported differently. Changed all tables to Import only and re-published the dashboard, all issues resolved.

Thanks for the help in any case Farhan.

[FarhanAhmed]

you are welcome

[Kit]

Yes have signed in successfully each time I check the gateway, but it does seem to always ask me to sign in.

Also ran a gateway portal network test and all passed, screenshots below.

Do I need to delete my dashboard and re-publish?

[FarhanAhmed]

In PBI Service go to gateway settings

Click on 3 dots against your Data source and go to settings

Under settings try re-enter credentials and test connection of your data source.

[Kit]

Updated and saved the connection, no errors but this message appeared. Still cant refresh the dashboard.

[FarhanAhmed]

Make sure that you have updated/reenter the credentials of data sources again.