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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!:
The Definitive Guide to Power Query (M)

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors