Forum Discussion

-Rem-'s avatar
-Rem-
Frequent Visitor
5 years ago
Solved

Dataflow shows connection to Web data source when I am not using any

I have created a new dataflow and if I look at it in the PBI Service, the Lineage View is showing a Web data source. Similarly, in the settings for the flow, there are credentials for that particular data source.

 

 

However, if I open up that particular data flow, I am never accessing that web data source in any of my queries. They are all either sourced through "Enter Data" or coming from SQL Server.

Ultimately, I'd like to remove this unused web data source because I fear it will cause problems further down the line. How do I best go about that?

Need Help
  • -Rem-'s avatar
    -Rem-
    5 years ago

    Well... exporting the JSON and re-importing it made the Web source go away. Still not sure where that web source came from (originally I tried using Excel on OneDrive as a source but I never selected a file so I did not expect this to create a source entry) but this issue is fixed now. 

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago
    Hey -Rem- ,
     
    did you check the advanced editor for each query?
    Maybe one step is using the web source without showing it in the linage.
     
    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • -Rem-'s avatar
      -Rem-
      Frequent Visitor
      5 years ago

      Hey Denis,

       

      I checked now and for every query it shows me as source 

      Source = Table.FromRows(...) when the source is Enter Data and 
      Source = Sql.Database(...) when the source is SQL Database. I see no calls to Sharepoint in the M code for all the queries. 
       
      Best wishes
       
  • -Rem-'s avatar
    -Rem-
    Frequent Visitor
    5 years ago

    Well... exporting the JSON and re-importing it made the Web source go away. Still not sure where that web source came from (originally I tried using Excel on OneDrive as a source but I never selected a file so I did not expect this to create a source entry) but this issue is fixed now. 

  • Clucer23's avatar
    Clucer23
    Regular Visitor
    1 year ago

    Hello Denis,selimovd 

    I am also currently having trouble with this same issue. In my case I'm connected to SmartSheet and Sharepoint as a source and there should be no web connections. However, I still see a web connection in the flow just as pictured above. I checked the advanced editors in the querries and none of them display a web connection at all. I only see the SmartSheet and Sharepoint connections as the source. 

     

    The data source connection for web connection is failing now displaying this error "Failed to update data source credentials: The credentials provided for the Web source are invalid."  It, as a result, seems to also be preventing the dataflow itself to refresh or save any changes at all. 

     

    Thanks for any ideas/ solutions you might be able to assist with. 

     

    Colleen