Forum Discussion

ElmerVMN's avatar
ElmerVMN
Regular Visitor
5 years ago

Refresh dataset connect to SQL and shared Power BI Dataset

I have created a dataset what is connect to SQL and a shared Power BI dataset.  If I refresh this report locally in the Power BI desktop it works fine..  The problem is if I try to refresh the repport in the cloud I am getting a error. 

I configured the Gatewaysettings correctly and have also provide a login to the references.


Do I need to setup something else ?  I am not sure what I have done wrong... or do different ?

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    ElmerVMN , On the first file/ dataset, where you configured , go to dataset setting and make sure connection details and  gateway details.

     

    For the second file, login to power bi the connection setting -> Under setting of dataset

  • ElmerVMN's avatar
    ElmerVMN
    Regular Visitor
    5 years ago

    Hello amitchandak,

     

    Thank you for your advise but I have done earier that exactly how you explain.

     

    The login (OAuth2) goes create.. but when trying to refresh in the cloud I am getting the error.

     

    Is it something with the login ?  (Because If I refresh the set in Desktop it works)

     

    Regards