There is no available gateway in User Usage Metrics Power BI

[Orquisa]

Hello community!

I'm having a problem with using the Power BI Usage Analytics Dataset

The user's data is loading on my desktop Power BI, but when I publish, the "There is no available gateway" appears in the charts or tables that contains the data

The error:

The table corrupted:

The Dataset working in my desktop:

Does anyone knows how to solve it?

[v-zhangti]

Hi, @Orquisa 

The gateway is personal gateway or standard gateway?  The personal gateway don't support the data sources with direct query/live connection mode.

Please refer to the following link, hope it can help you.

https://community.powerbi.com/t5/Desktop/there-is-no-available-gateway/m-p/1669267#M666601 

https://community.powerbi.com/t5/Service/quot-There-is-no-gateway-available-quot-error-with-report-u... 

https://community.powerbi.com/t5/Desktop/There-is-no-available-gateway/m-p/1912562#M731610 

Best Regards,

Community Support Team _Charlotte

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

[Orquisa]

Informations that can help with the solution:
The Power BI that I'm creating is using sharepoint data and PowerBI Direct Query, maybe this is a problem

And if I recreate the Power BI with just the Direct Query, it works (But I don't know for how long, because in the beginning, the one with both datas was working too)