Forum Discussion
Helper IINew web data source suddenly appeared in settings for Dataflow Gen1, cannot be authenticated
We have many dataflows Gen1 (we dont have a Fabric license and will not get it any time soon) upon which we rely pretty heavily in our reporting structure. Some of these dataflows have the settings created with a service user (Windows account created for gateway connection, password never expires, is only used for Power BI Service purpose, is not used in business anywhere else), also the data source credentials are authenticated with this user's credentials. This has been running without issues for a long time, suddenly yesterday in some of the dataflows' setting a new data source appeared "Web", which then fails to connect. There is NO actual web data source in any of the dataflows.
When shown in lineage view, I see that this web link leads to a OneDrive account of this service user with a message that we cannot edit files because the license to use OneDrive ended and to contact our IT to assign by xxx date (the date changes, yesterday it showed yesterday's date, today today's date)
According to our IT support the user has a license and there is no history of removing it.
Does anyone experience something similar? What has OneDrive have to do with the Power BI authentication? And how can we get rid of that data source?
I have found this thread https://community.fabric.microsoft.com/t5/Service/Dataflow-shows-connection-to-Web-data-source-when-I-am-not-using/m-p/1779839 however we cannot use the solution of exporting .json and then creating the dataflow anew because that would mean having to change the dataflow ID in all related reports, that is not manageable.
For now we have taken the not yet affected dataflows over with a normal user and the affected ones we did the json export and recreate.
The issue was not solved yet. We have discovered that the affected dataflows do refresh despite the web source not being able to authenticate. Microsoft for now cannot reproduce the error and has no solution as of now
8 Replies
- Thomaslleblanc
Super User
Create a support ticket with Microsoft to help with the issue
v-echaithraCommunity Support
Hi KaterinaB ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.
KaterinaBNot sure what do you mean with "solution provided for the issue worked"? The suggestion below to open a ticket is a good one, but it is not a solution. We opened the ticket with MS and are waiting for feedback.
- v-echaithra
Hi KaterinaB ,
We would like to follow up to see if the issue got resolved by the support.
If yes i request you to post the solution here and please accept your own post as the solution, this will help other community members who might face a similar issue.
Thanks again for your contribution!
Regards,
Chaithra E.- KaterinaB
The issue was not solved yet. We have discovered that the affected dataflows do refresh despite the web source not being able to authenticate. Microsoft for now cannot reproduce the error and has no solution as of now
- v-echaithra
Hi KaterinaB ,
Thank you for sharing your update and confirming that you dont have any issue. i request you to please accept your own post as the solution, this will help other community members who might face a similar issue.
Thanks again for your contribution!
- SaiTejaTalasila
Hi KaterinaB ,
I have seen similar kind of issue in one of our dataflow. Open your dataflow and check all your queries and parameters. In our case we have a parameter with datamart, and we have deleted it after analysing all queries.
I hope this helps.
Thanks,
Sai Teja
