Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting 401 error while connecting to Azure DB in PBI Report Builder

I'm getting the following error when i click Run on a paginated report in PBI report builder : 
The remote server returned an error: (401) Unauthorized.
----------------------------
The connection either timed out or was lost.

 

I'm using a Azure SQL DB and providing the correct credentials.

The Test connection is succesful and I'm able to see the preview of the data in the query designer.

Please advise. Thanks in Advance.

  • Anonymous ,

     

    Please try changing the connection timeout settings in Azure SQL DB and check if this issue persists.

     

    Community Support Team _ Jimmy Tao

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

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    Please try changing the connection timeout settings in Azure SQL DB and check if this issue persists.

     

    Community Support Team _ Jimmy Tao

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

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

     

    Regards,

    Jimmy Tao