So, this whole thing is confusing to me, and the forums appear to have conflicting answers based on when the post appears. My company has a SQL Server Database in Azure. I have downloaded Power BI Desktop and can create reports by using a "SQL Server" connection or an "Azure SQL Server" connection. So, from the Desktop, I can get what I need. I'm using Direct Query, BTW.
What I really want to do is have my report out in the PowerBI workspace area AND have it connected to LIVE or FREQUENTLY REFRESHED data. Sounds like a VERY common use case. So, how do I do it? Is there a recipe or architectural diagram?
I actually have some reports out in the web workspace that I created before I upgraded to "pro". They work fine, but don't refresh to live data. Since I upgraded, I can publish reports but it tells me "the published report can't connect to a datasource because we were unable to find a gateway. Please install and configure an enterprise gateway."
Do I need a gateway? Which? Why?
I can get more detailed, but figured I'd start with that main idea.