On-prem data unreachable in a local copy of pbix file

[ericOnline]

Hello,

How do I connect a .pbix file to an on-prem data source such that it can be edited locally (while on VPN)?

Scenario:

- .pbix file stored in a shared folder on-prem

- Connected to our VPN

- If I open file using PBI Desktop, no problem editing/saving/etc.

- If I make a copy of the .pbix file and store it locally, even while connected to our VPN, I get a bunch of errors:

[v-kelly-msft]

Hi @ericOnline ，

Can you advise me in which mode do you connect the data source of Sql?Import Or direct query?

Can you take a screenshot of what is in advanced editor?From your pic,it seems a data source error,but I need more details to confirm it...

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[ericOnline]

 Hi @v-kelly-msft , 

I inherited this PowerBI report. I'm unsure how to determine the method (direct query or import). Where do I look for this info?

Here is the code (redacted) from Advanced Editor:

let
    Source = DB2.Database("test.db.mycompany.com:1111", "dbName", [HierarchicalNavigation=true, Implementation="Microsoft"]),
    TST = Source{[Schema="TST"]}[Data],
    TABLENAME = TST{[Name="TABLENAME"]}[Data]
in
    TABLENAME

And here is the (redacted) error message:

DataSource.Error: Microsoft Db2 Client: No such host is known SQLSTATE=08S01 SQLCODE=-1336
Details:
    DataSourceKind=DB2
    DataSourcePath=test.db.mycompany.com:1111;dbName
    Message=No such host is known SQLSTATE=08S01 SQLCODE=-1336
    ErrorCode=11001

 Thank you

[mwegener]

Hi @ericOnline ,

what kind of VPN Software do you use?

[ericOnline]

Hi @mwegener . Its a major vendor. Nothing niche. (I don't usually speak about these types of things on public forums).

[mwegener]

Hi @ericOnline ,

but you are sure that it is a VPN and not a terminal access such as Citrix.

Because it is surprising that the same Power BI desktop installation should use a different connection depending on the storage of the PBIX file.

[v-kelly-msft]

Hi @ericOnline ，

Based on your description,it seems an individual issue,better create  a support ticket via below link and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[ericOnline · Accepted solution]

The fix ended up being:

- I need to connect to VPN and manually refresh each time I transform data

- Clicking the "Refresh" button here worked

[mwegener]

Hi @ericOnline ,

what kind of VPN solution do you use?