I have two on-premise SQL Server databases defined as Data Sources in Power BI for Office 365. The Gateways and Data Sources are healthy.
One of the developers created a test workbook and I can refresh it but he cannot. Also, when I schedule the recurring refresh it works, albeit inconsistently. We are using the same SQL Server account in the Data Source as well as the Workbook.
So we actually have two issues -
1. The refreshes don't work consistently as you will see in the screenshot. Sometimes they take too long...I wonder if this is due to instability / ongoing issues in the office 365 power bi platform. There has been a service degraded message for a few days. But no way to figure out exactly what's going on. Also, I am aware that refresh time will depend on the latency between the Office 365 SharePoint site and our on-prem data source.
2. Can't figure out what's wrong with my developer unable to refresh. I am the admin. The connection string in the workbook and the data source is the same since I am able to refresh it. I also added him into the Global Adminstrator Group to see if that helps but no dice.
3. The Power BI pages seem to be rendering in Spanish frequently without any changes on our part. Wondering if anyone else is having these problems.
Any and all assistance will be greatly appreciated.
On the other side of things, it sounds like your developer does not have access to the SQL Server but that doesn't sound quite right. Sounds like you are using an Excel file and is your developer searching for the data source and downloading the query and then trying to use it?
Thanks for the tip on the Spanish issue. Regarding my developer, he's created the workbook. We validated the connection string on the data sources and his workbook which contains the power pivot table & visualization is the same. But when he tries to refresh it on the SharePoint / Power BI for Office 365 site, he gets an error. But I don't....The userid and password we are using is the same so it made us wonder if something's wrong with the SharePoint / Power BI Site. I even tried making him an owner of the SharePoint site but no dice.