Forum Discussion
Helper IDirect Query, SQL-server 2012 publishing error
Hello everyone,
I have a local machine running SQL-server 2012, Power-BI Desktop and the On-premises data gateway.
They are all running under my personal user-account with local admin rights.
The report consist of two datasets, one with a custom visual and one normal bargraph. The data is a retrieved using Direct Querys
In power BI Desktop I get the following warning:
In App.powerbi.com:
Testing the HTTPS connection to microsoft:
I can PM the loggs if someone want to have alook at them.
Thanks!
FunDeckHermit,
Go to Settings->Manage Gateways, add SQL Server data source within gateway following the guide in the article.
Regards,
Lydia
10 Replies
FunDeckHermit,
What server name and database name do you use when adding the SQL data source within your gateway? Please make sure that the server name and database name are same as that you use in Power BI Desktop.
In addition, do you use "." as server name in Power BI Desktop? Do you install gateway and SQL Server in a same machine?
Regards,
Lydia- FunDeckHermit
Hello Lydia, Anonymous
I use ServerName: .
And databasename: CompanyProduct nx Datalogger
These settings were used everywhere, power BI desktop, query builder and even the gateway.
With regards,
RoyFunDeckHermit,
Do you install gateway on the same machine that installing SQL Server? If not, please change your ServerName to machine name or IP address in your PBIX file and gateway.
Regards,
Lydia
