PowerBI

Power BI Change Source option is disable/Option is greyed out

We have observed Power BI change Source option is greyed out or disable hence we cant change the source from Dev to UAT or Prod .

Lets look at below image where changes source option got disable that means you cant change the source .

we have tried to search the solution from Microsoft , but sometime that cant help that much to fixed the issue .

please refer the article by Microsoft below :-

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Why-can-t-I-change-the-Data-Source-in-Power-BI-disabled-button/ba-p/915365

In my case i have found different solutions :-

Please open the power Query and let each and every table which have any source like SQL, SharePoint , Excel, etc..

Once you open table like below you can observed the change type have(yellow) source(SQL code) information that M code present ,As per standard that M code should be in source not in change type .

because of that source changes option got greyed out on data source setting in power BI .

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top