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:
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!