Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Editing & Applying Queries on Imported SQL data when Offline ( outside of company firewall).

Hi All,   Can I check my understanding of editing and applying queries for an imported data source when not connected to the SQL database.   I'll preface it with that I understand the core differ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    I test it using SQL Server profiler to trace the SQL Server connections. When we edit in Editor Query, for example we remove several columns in Editor Query, it will connect SQL Server can select the only necessary columns. You can still test it in your local computer.

    When you open the .pbix file at home, the connect to SQL Server is denied. The first step to get the datasource failed, you can't edit the data using Query.

    Best Regards,
    Angelia

YasirK's avatar
YasirK
Frequent Visitor
8 years ago

There should be an option to spool or modify query offline without getting the unable to connect error. I have the same problem.

Frede's avatar
Frede
Helper I
7 years ago

Agreed, this should really be implemented. the data is already imported into the model, is there any technical reason why we cannot modify the queries without a connection?

 

Regards

Fredrik