Azure SQL DW authentication issue with POwer BI data source

[Anonymous]

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.

[v-cazheng-msft]

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]

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.