Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
General Comment
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

A manual refresh in the service does not work. I've updated the Gateway to the latest version, it is working to refresh my other reports. 

 

My workspace is not PPU, but I created a new Pro workspace anyway and uploaded a new version of the dataset, still no luck. I wonder if the SQL server has some type of security with the native DB query through the Gateway.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Do you have any of the messages shown below in your failed refresh history? Could you please share them? I will try to see if I can use this information to find the specific error message.

    If you use a personal gateway, can the dataset refresh successfully?

     

     

    Best Regards,
    Winniz

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Winniz