pbix file sharig

[nix]

I have built some pbix report and have published that,for the report i have used sql server.
Now i want to trasnfer all the file from my desktop to another one for which i have RDP access.
But when i am opeing the same file in RDP acess in that desktop then getting error and file is not in editable mode,where as i have installed Powerbi Desktop in that desktop also  ,even i tried some other desktop also ,
but the result is it is not in editable format and table view have data but visual have not data 
I have not changed the data source also,
Any changes i have to make in desktop level before sharing or what to do
I am attaching the screen shot of error msg
Please guide me
TIA
Sonali

[v-huijiey-msft]

Hi @nix ,

My following up is just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[nix · Accepted solution]

I have solved this,just by changing settings and preview features .
Thank you 

[v-huijiey-msft]

Hi @nix ,

rohit1991 has provided good advice that you can refer to. Other than that, I have a couple of additions:

First, check that the version of Power BI Desktop you have installed on your new desktop is the same or higher than the version used to create the .pbix file.

Then, try refreshing the data after clearing the cache. Go to File >> Options and Settings >> Options >> Data Load >> Clear Cache “Clear Cache”.

One last suggestion, try to re-upload the .pbix file to the power bi desktop in the new environment and check if the problem is back or solved.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[rohit1991]

It seems the issue arises because the Power BI file references a SQL Server database that the new environment cannot authenticate or connect to properly. Here's how to resolve it:

Steps to Fix:

1. Ensure Data Source Accessibility:

   • Confirm the new desktop with RDP access can connect to the SQL Server used in the .pbix file.
   • Check network permissions and firewall rules.

2. Update or Reconfirm Credentials:

   • Open File > Options and settings > Data source settings in Power BI Desktop.
   • Edit the credentials for the SQL Server data source. Use the correct authentication type (Windows, database, or organizational).

3. Verify Server Name:

   • Ensure the SQL Server name or instance name matches what was used in the original desktop environment.

4. Enable Editable Mode:

   • If the file is marked as "view-only," ensure you have full file permissions in the new environment.

5. Test with Dummy Data:

   • To isolate the issue, replace the data source temporarily with a local or test database to ensure Power BI itself works fine in the new desktop.

If the issue persists, please share more specific error messages, or check with the SQL Server admin to validate the connection settings.