As the title says, my Direct query works in PBI Desktop, but I'm unable to make it work in the PBI Service.
I edited my credentials to:
Authentication Method: basic
Privacy Level: None
(then, database user name and password)
When I access the report, visuals show errors.
I didn't create a gateway because Azure Sql Databases doesn't require it.
What could I be doing wrong?
You may refer to this post:
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.