Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

how to delete invalid data source credentials for a dataflow

 Capture.PNG

I have a dataflow has 3 credentials while 2 of them are invalid and stopping dataflow from refreshing. I just want to know how can I delete the invalid credentials.

I've checked the queries in this dataflow, data source comes from only one single sharepoint folder.

the reason of those invalid credentials could be due to previous sharepoint folder links.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, I think this might work.

 

After changing all your current dataflow to point to valid credentials, do the following:

  • From your workspace with the dataflow > select the workflow > ... > 'Export .json'
  • Click New > Dataflow > select 'Import Model' and select your exported .json file from previous step.
  • A new version of your dataflow is created with a (1) at the end of the name
  • Delete the old Dataflow and rename your new dataflow with the same name

The new Dataflow will only have the valid credentials (no errors if you made the changes correctly).  You may have to relink any reports or datasets that use the flows to the new one.

 

I have not figured out any method for simply removing unwanted connections.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi, I think this might work.

 

After changing all your current dataflow to point to valid credentials, do the following:

  • From your workspace with the dataflow > select the workflow > ... > 'Export .json'
  • Click New > Dataflow > select 'Import Model' and select your exported .json file from previous step.
  • A new version of your dataflow is created with a (1) at the end of the name
  • Delete the old Dataflow and rename your new dataflow with the same name

The new Dataflow will only have the valid credentials (no errors if you made the changes correctly).  You may have to relink any reports or datasets that use the flows to the new one.

 

I have not figured out any method for simply removing unwanted connections.

Hello, I've solved the issue by editing the dataflows and refreshing the faulty sources. I was then prompted to enter a valid credtial and it succeeded. 

Anonymous
Not applicable

actually I have done it in a similar way, to re-build the dataflow.

I created a dataflow with blank query and copy&paste queries from old dataflow. exporting json file is an easier way.

Greg_Deckler
Super User
Super User

@Anonymous Use the Edit credentials link to edit the credentials.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Capture.PNG

@Greg_Deckler thank you for reply. I have looked in edit credentials. there is only options and "sign in" button. I don't have the access to this sharepointsiteUrl now, therefore not able to sign in.

since my dataflow doesn't use any datasource from this sharepointsiteUrl anymore, so I just want to delete this credential if ever possible.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!