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? Please Advise

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

Accessing Data From Home | Microsoft Fabric Community

3 Replies

amitchandak
Super User
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

3 Replies

Related content

Unsolveable Mashup Data Access Error

Unable to access any Data Model

Fabric Data Science Tutorial - Sample Data not accessible

SharePoint Access

Connection Access