How can I eliminate a data source with the handicap explained inside?

[vicentetic]

Hello,

Maybe it is very simple, but we are stuck at this point. 

How to delete a source of information when the "change source" button is greyed out and does not allow access to do it?

Thank you in advance,

Vicente

[Anonymous]

Hi @vicentetic

Thank you very much rajendraongole1 for your prompt reply.

I noticed your post when I was checking the forum. Have you solved your problem?

If not, here is some information for you.

There might be a case where you will find the change data source button is greyed out which means this option is disabled or unavailable.

In this case, import the data from new data source as new table and copy its whole Advance Editor code and paste it in the Advance Editor of your existing or previous table.

Before doing this make sure table structure & the transformation applied in both the tables should be same. After this you can delete the new table & data source of your previous table is changed.

Why can't I change the Data Source in Power BI (di... - Microsoft Fabric Community

https://addendanalytics.com/blog/how-to-change-the-data-source-in-power-bi/

As a last resort, you can export the current Settings using the "Exportar PBIDS" button, make the necessary changes in the exported file, and then re-import. 

Regards, 

Nono Chen 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[vicentetic]

Dear rajendraongole1,

Thank you for your answer, but it doesn't work. I tried this option, but the button keeps graying out.

[rajendraongole1]

Hi @vicentetic - In the "Data source settings" window, you can view all data sources used in the current report.If the "Change Source" button is greyed out, try selecting the data source and see if the "Clear Permissions" button is available. Clearing permissions might allow you to reset and redefine the data source.

Hope it works