Personal experiance. There are very few organizations that I know of that would be happy with Free.
Some of the largest limitations are 1x refresh of data per day, no connections to on premises data sources via the gateways, and not being able to use Groups.
The free version is designed to wet your appetite and allow you to see how things work. If the company is ok with seeing a daily report, and you can work around the limitations - cool. But in my experiance that is a rarity.
@Seth_C_Bauer strange, because im currently on a 60-day pro trial and i've created about 5 different dashboards which all have automatic refresh (which is a pro feature) and shared the dashboards with non-pro users. They can all view it.
@tschmidt87 Interesting. Shouldn't work if the end users are purely on "free". If they have "Free with Pro Trial" - like you, I would expect it to.
Point of clarification. You aren't using a live connection. You are importing data. Live Connection refers to connecting to a SSAS cube or model and your data is always up to date.
Direct Query refers to connecting to a SQL Database - also always up to date
Import - You need to schedule a refresh because the data is static.
So if you scheduled a refresh, then you are importing data. In either case, you are using a personal gateway which requires a Pro license. So unless something changed, I would consider the fact that it works right now ... temporary.
Thats the thing. It does work, using the database connection that i set up via Desktop. Every day at 10AM this is being updated using the MySQL credentials stored in the "Automatic Refresh" section on PowerBI Service. Sorry if i am not fluent with PowerBI-specific terminology, i'm relatively new to it.
As it stands, my organization could easily use PowerBI for free with simply one account being enabled for PRO features (me, for example). However, i can literally not find a single piece of information regarding this anywhere. I need to decide in the next weeks if my Organization can afford PowerBI (one or two Pro users) or not (hundreds of Pro users).
I'm not too sure which decision to take simply because everything is fully functional for our users without having Pro (or a trial thereof). I guess i will give Support a call