Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Remove data connection but keep data like data table

I got my data from SQL database. When the report is ready to share with partner, I want to remove the data connection but keep data like data table. The concerns are, I don't want partner to click ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    I think here you share the PBIX directly to others, right?

     

    1. Even they can click the refresh button, credentials are required. So the users will get the error message as below.

     

    2. To use localhost instead of server name. For the database name, no work around here.

    3. Although they can see the step names in power query from APPLIED STEPS, but they can get nothing from that.

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

I think here you share the PBIX directly to others, right?

 

1. Even they can click the refresh button, credentials are required. So the users will get the error message as below.

 

2. To use localhost instead of server name. For the database name, no work around here.

3. Although they can see the step names in power query from APPLIED STEPS, but they can get nothing from that.

 

 

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.