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
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Is the gateway datasource using the same credentials as power bi desktop? Eg if you're using  windows authentication it might not be.

 

If it's not try running the query in SSMS with the same login (can wrap query in EXECUTE AS LOGIN = 'DOMAIN\Account'; <Your Query>; Revert; 

 

Another thing to try is loading SQL Server Profiler, starting a trace and then refreshing your dataset in the service. It might let you see if it's a sql server issue or not.

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    Something else to try. Oddly I've just had a very similar sounding issue this morning.

     

    Nothing was even reaching the SQL server when watching profiler so concluded it was service side. 

     

    Workspace was in PPU but dataflows were simple loads on prem DW eg no need for compute. I dropped the workspace out of premium and everything has refreshed. I've now restored it to being a PPU workspace and everything is now working again.

     

    Can't even start to explain it - will put my own post in on forum.