Azure SQL DW authentication issue with POwer BI data source

[johnf]

Hi.

I'm having an issue where I have established a connection to a Azure SQL DW instance with Power BI desktop and the credentials are working in desktop.

When I publish to PBI Service it asks for the credentials again for the data source. I've used all assigned accounts and up to the DB Admin but no joy. I keep getting "The credentials you provided for the data source are invalid. Please check the credentials for all the data sources."

I have also logged in to the SQL DW instance and tried the direct attach method from there, going back to Power BI Service (it connects and displays fields but when I tried building a report in PBI Service I get

"Couldn't load the data for this visual Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details"

I'm stumped, what am I missing?

Cheers,

John.