Forum Discussion
Working with SQL Server, greyed out gateway, report authoring
According to this article, the database name and server name used in Power BI Desktop have to match with whatever is used by Power BI Service (the online portal).
Ergo, if you author a report, you will have to be able to read the data from the production database that will be used by the data gateway. If you are working in an environment where physical access to the hosting site for the production database is not available, you'll likely have to do something else like a) extract the data from your production database to delimited files and then put them on Power BI-aware location or b) start using Power BI Service as the data source instead of a SQL Server database.
"Server and database name have to match between Power BI Desktop and the data source within the on-premises data gateway gateway!"
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/
According to this article, the database name and server name used in Power BI Desktop have to match with whatever is used by Power BI Service (the online portal).
Ergo, if you author a report, you will have to be able to read the data from the production database that will be used by the data gateway. If you are working in an environment where physical access to the hosting site for the production database is not available, you'll likely have to do something else like a) extract the data from your production database to delimited files and then put them on Power BI-aware location or b) start using Power BI Service as the data source instead of a SQL Server database.
"Server and database name have to match between Power BI Desktop and the data source within the on-premises data gateway gateway!"
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/