Scheduled refresh is failing when data source is "Excel.Workbook(Web.Contents("
My dashboard sources are mostly open sources (web), one of them is an excel with multiple sheets: "https://www.bag.admin.ch/dam/bag/de/dokumente/mt/k-und-i/aktuelle-ausbrueche-pandemien/2019-nCoV/covid-19-datengrundlage-lagebericht.xlsx.download.xlsx/200325_Datengrundlage_Grafiken_COVID-19-Bericht.xlsx" According to Microsoft Docs, a gateway is required for .xlsx, therefore I have set up an on-premise one and it runs correctly. Besides this, I can easily do a manual refresh. But using the scheduled refresh i receive the following error message: XY has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"File contains corrupted data."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: XY. Has anyone experienced a similar situation? How could i fix that? Thanks a lot for your help, i am kinda lost. 🙂"Windows" Datasource Permission Allows Refresh on Desktop Cannot Refresh Report on Workspace
Hi, I have a report that pulls data directly from a web page that we use to view historical data. The webpage allows me to download the data I want to an excel file, but this requires me to manually download the data each day to update my report. Our software team created an option to output a URL once I've selected the parameters for my download, and I inserted that URL as a "Web" datasource in Power BI. The only option that works for the Desktop version is "Windows" ("Use my Current Credentials") for the credential input, and that allows it to work just fine in the desktop file. The Query Source is in the form (spots in brackets are removed for security): "Json.Document(Web.Contents("http://[companysite].com/PlantView/[Download Parameters]", [Timeout=#duration(0, 0, 30, 0)]))" However, when I publish the report and access the dataset from the workspace to set up a scheduled refresh, the settings I setup in the desktop file are not on the workspace and it only shows "Anonymous" or "Basic" as options for connecting, and neither works. I tried using either of those from the deskop file, but they didn't work either. Is there any reason that the Desktop allows for "Windows" input for credentials but the Workspace doesn't? At the moment, I have to refresh the desktop file and republish it every time I want the downstream viewers to get up-to-date data. Not sure if it's related to the datasource type or if it's a function of the webpage itself.
Scheduled Refresh Not Working for Web source on Window Authentication
I have built a Power BI report that is using WEB as datasource. The Web source is getting data from API that is running on Windows Credentials. Everything is fine in Power BI Desktop, establishing connection with API using Windows credential, showing data and refreshing report. However, If I upload PBI report on On-Premises Report Server, Authentication Type of PBI Report data source changed to "Anonymous". If I try to change Authentication type to Windows again it gives error "Couldn't connect The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. Hide error details Unable to connect to the remote server" I not am sure why authentication type changed from "Windows" to "Anonymous" after uploading and doesn't allow to change after that. Main objective is to configure "Scheduled Refresh" to refresh data. Please advise solution or suggest any alternative to "Scheduled Refresh" when Datasource is Web, Report is deployed on Power BI Server[On-Premises] and user is authenticated by Windows Credential.