Forum Discussion
Issue with Gateway On Premises
Community SupportHi, Anonymous
What type of data source and connection mode are used for the latest report you publish? If you can't connect to the data without a gateway, this problem may occur.
You can go to the dateset>>setting to view the refresh history and see what is wrong with it.
If it doesn't solve your problem, Please share more datails and feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-janeyg-msft,
Thanks for your response, the data sources used are a combination of excel sheets and data from sql server, and using DirectQuery to connect to the SQL database.
The issue is there is no gateway, but we have never had a gateway set up previously, and the reports used to work before, but now none of the reports are working
- v-janeyg-msft
Hi, Anonymous
You use the DQ mode to connect to the database, which must use the gateway to get the data.
I don't know why you can run the report without a gateway before, because unless you use cloud data, you can refresh as long as you add credentials. Even if you use the import mode, the local data needs a gateway to refresh. Unless you don't refresh.
You can learn and download from the link below, then configure the gateway.
On-premises data gateway - Power BI | Microsoft Docs
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.