Power bi Sentiment Analysis credentials error after publishing the report

[MSAKRAM]

i have a report where text sentiment analysis and text translation is made which is working fine in power bi desktop. My data source is connected with SharePoint Excel file(Microsoft Forms)

The problem is when I publish the report in power bi web and when new data comes in my excel when I try to refresh my dataset in my power bi web It shows 'Resource not found' error for sentiment analysis url. When I remove sentiment analysis from my report and re publish the report and when new data comes it is refreshing and no issues

When issue occurs when I try to fix the credentials There are only two credential option one is Anonymous and other is basic trying to connect with any of these is not working. 

But it is perfectly working in power bi desktop while resfreshing the dataset.No error message such as 'Resource not found'.

Hope anyone find the solution 

[v-yalanwu-msft]

Hi @MSAKRAM  ,  

From your description, you could click edit credentials and check if the "SharepointSiteUrl" starts as https:// ;

if so,  you could change it to https:// in the Power BI desktop file and republished it after which edit credentials came up with 3 options (Anonymous, Windows and OAuth2). then selected OAuth2.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MSAKRAM]

There is no issue with sharepoint excel file connection with the power bi its shows 3 options (Anonymous, Windows and OAuth2) and i choose OAuth2 and connected already but the exact issue is  my report contain sentiment analysis and text translation services which is working perfectly in power bi desktop when i refresh the data source when new entry comes but when i publish the report and when new entry comes sentiment analysis and tranlstion service is not working showing resource not found. So in the edit credential section it shows two option 'Anonymous' and 'Basic' both are not working after providing credential for Sentiment analysis and Translation. I think you got my exact problem now "Need to run sentiment analysis and translation service when new entry comes in excel for power bi after publish(Working perfectly in power bi desktop)"