Forum Discussion

Regular Visitor

6 years ago

Solved

Accessing Data From Home

Hi all, I am trying to create DirectQueries from home. Is it possible to use PowerBi Desktop from my home to access data at work, through a data gateway that is living on a server at work? ...

Tips and Tricks

amitchandak
6 years ago
CadMachine , Direct query means you need to have access to the database that can be using VPN or IP whitelisting etc. Gateway is used to supply data to Power BI service

CadMachine

Regular Visitor

6 years ago

amitchandak Thanks for your quick response.

Am I able to access the data supplied to the PowerBi Gateway at work, from home? I have installed PowerBi Desktop and I am trying to run queries. But I get the following error:"

Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

This happens only when I am not at work. How can I work from home using data from work?

amitchandak
Super User
6 years ago
CadMachine , because from your home you are not able to access the database. You need to work with your IT to get that.

You can also explore the option of using SQL server express edition as you dev database

refer example

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885

Forum Discussion

Accessing Data From Home

Related content

Unsolveable Mashup Data Access Error

Unable to access any Data Model

Fabric Data Science Tutorial - Sample Data not accessible

SharePoint Access

Dashboard Access