Forum Discussion
Refresh not working - no error message (Native DB Query)
Hi everyone! I have a report which uses SQL Server Import. The report refreshes fine in the Desktop, but when I publish it to Power BI service it runs a refresh for about 45 minutes then fails wi...
Hi! Thank you for the reply. We just updated to the latest gateway and it works to refresh our other reports.
Unfortunately the error message is empty and the refresh takes a long time before it fails. Both manual and scheduled refreshes fail in the service. But a manual refresh on Desktop works without issues.
For the SQL query, I entered it using the method you descibed, and in Power Query editor it shows as the below format (but contains the actual real query)
let
Source = Sql.Database("Server-Name", "DatabaseName", [Query="select * from Table"])
in
Source