scheduled refresh. web source

2 Topics

Scheduled Refresh with Web Source Not Working
Hi all, I have built a PBI report on PBI Desktop using SQL database and Web as data sources. The Web source is used to call http://useragentstring.com and the report passes user agent values in a table to extract user agent-related data (via Invoked Function) Source = Json.Document(Web.Contents("http://useragentstring.com/?uas="&userAgent_URLEncoded&"&getJSON=all")), All work fine in PBI Desktop - refreshing the report works there. However, it does not work when I publish the report to on-premise PBI Report Server and run scheduled referesh. The error is: SessionID: f327bfa4-fb1c-4662-ab33-a1340c81e00f [0] -1055784932: Credentials are required to connect to the Web source. (Source at http://useragentstring.com/.). The exception was raised by the IDbCommand interface. [1] -1055129594: The current operation was cancelled because another operation in the transaction failed. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. If I go to Data Sources on the left hand side, it only shows the SQL data source there and I have authenticated it using a service account successfully. The Web Source does not appear in this section. When I go to the PBI Desktop > Edit Queries > Data Source Settings, under "Data sources in current file", it only shows the SQL source there, though there is a warning above the buttons saying "Some data sources may not be listed because of hand-authored queries". Not sure what this warning is for and if it is relevant to this issue. If I go to PBI Desktop > Edit Queries > Data Source Settings, under "Global permissions", I can see http://useragentstring.com/ there and if I click on Edit Permissions, the Credentials type is Anonymous with Privacy Level = None. Not sure why http://useragentstring.com/ is on "Global permissions" not in "Data sources in current file". Can this be why the scheduled refresh does not work because the permission to that URL is not explictely configured in the file? If so, how can I add this data source to "Data sources in current file" section? Thanks P.S. If there is a better (and free) way to extract useful data (e.g. OS type, OS version, browser info, etc.) from given user agent values, please let me know also.
Solved
Anonymous
5 years ago Place Report Server
27KViews
1like
12Comments
One Drive auto refresh on PBI RS
Hey, guys! What's up? I have an dashboard that uses a few data from Google Analytics, and I found out in the moment that I published on my on premise PBI Report Server, that was not a connector avaiable for auto refresh. So, OK. I did a little trick using Google Sheets, Microsoft Flow and One Drive for Business to create and update a *.csv file with the information I needed. Then, I went to my dashboard and create a new source with the direct link to One Drive, put my Organizational Credentials everything was beautiful until I deployed again to PBI RS. The type "Organizational Account" isn't avaiable on the schedule configuration. Is it really impossible put it an One Drive file on auto refresh?
Anonymous
6 years ago Place Report Server
711Views
0likes
1Comment