Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Re: Azure SQL DW authentication issue with POwer BI data source

Hi johnf  .  I'm having the same problem but 5 years later and with credentials to the Azure's cognitiveservices instead of SQL DW.  It works well on the desktop but the powerbi service thinks the credentials are not valid.

 

If you are still out there and have an answer, we'd love to hear from you. 

 

Thanks.

2 Replies

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    Hi, Anonymous 

    You can try to Edit credentials for the dataset in Data source credentials in the Setting pane of the dataset after publishing the report to Service. And you can refer Azure SQL Data Warehouse with DirectQuery, this official may help you solve your problem. For enhancing control over this data source, you can consider configuring gateway for the data source.

     

     

     

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you are looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • PaulW2's avatar
      PaulW2
      Frequent Visitor
      5 years ago

      Thank you v-cazheng-msft 

      However I've tried that several times. 

      I'm currentlly interacting with Microsoft support.  They are trying to tell me that I need to upgrade to power bi premium.  I pay for power bi pro and I pay for Azure's cognitive services.  The cognitive services authenticate when calling from my desktop power bi but not from the cloud power bi service.   I refuse to believe that the intention is to make us pay from "both ends" to run the service.  

       

      I'll try to remember to post more of what I learn here.