search

migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API
MIT License
238 stars 74 forks source link

CONNECTION PROBLEMS SINCE 01-08-2022 #131

Closed evertonthiago closed 2 years ago

evertonthiago commented 2 years ago

Since 01-Oct-2022 I am facing some trouble when I try to RUN this connector on POWER BI SERVICE.

While on DESKTOP it runs normally, but when I upload to my PBIX to the service / cloud and try to refresh it (or even define the gateway properties) tt shows me error's like "unable to connect", "gateway unreacheble".

I already tested with multiple power bi accounts, and also 3 different power bi personal gateway installed on different computers, and the error keeps runing when I try to run on POWER BI SERVICE

image

image

image

image

image

I also tested the gateway connection with another PBIX file (that not user this connector) and it is running normally.

image

image

I saw on microsoft documentation provided / updated on 29-july-2022 (https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport) that custom connector must have a test connection handler to work well.

Is there a connection between this error and this "new" microsoft update?

Is there any way to anyworkaround?

migueesc123 commented 2 years ago

hey!

I've tested the connector today and can't really repro any errors. If you can provide any repro steps, that would be great.

Based on your error message, it appears to be something related to the LIBERACAO_ACESSOS table and something about what happens in that specific query that is coming into issues. Perhaps it could be issues at the gateway level, so you might need to check the gateway logs to further investigate.