Latest Enterprise DNA Initiatives


Power Query Connection Error

Apologies if this is not the appropriate category for this question… Happy to repost in a different one or elsewhere.

Is it possible to develop in Power BI Desktop when working offline from the datasource? Here’s my scenario.

I have a client who cannot provide VPN access to the db server so I set up a local instance of MSSQL on my laptop, created a server alias so that I could dev remotely but not have to change the connection in the report back and forth between my host name and that of the db server. All good until I reinstalled the OS.

Now when opening power query, I get this error

And this in the SQL server logs:
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. (.Net SqlClient Data Provider)

Any guidance woiuld be greatly appreciated.

The short answer is yes. You can create Dev, Test and Prod parameters and assign the respective Data Source details to these parameters . You can then toggle between Dev (data source in local system), Test (Data Source in your PowerBI, OneDrive or dedicated Server on the intranet) and Prod (data source in client system), either on PBI desktop or on Power BI Service after publishing the dataset.

Also, once you initially connect to the data source and import the data to the data model, you no longer need to be connected to the data source during the development cycle. You only need to re-connect to the data source if you want to refresh the data model with additional or most recent data.

1 Like

Thanks for the suggestions. I’ll look into those. I managed to get this working again by changing the SQL server alias from TCP to Name Pipes.