Erro ao inserir credenciais na fonte de dados WEB (API) no Report Service
Eu tenho um dashboard que consulta uma api para trazer dados. Dentro do dashboard, os dados atualizam normalmente conforme a api é consultada dentro do Power BI. Entretanto, quando eu publico esse dashboard no servidor de relatórios e vou configurar as credenciais da API aparece o seguinte erro: "The remote server returned an error: (412) Precondition Failed" As credenciais estão certas, no dashboard os dados atualizam, mas na atualização agendada não consigo atualizar por conta de, na aba de fonte de dados, esse erro acontecer ao cadastrar as credenciais. Alguém sabe o que pode ser?
Power bi desktop to use existing Data Sources on SSRS URL
Hello, Trying to find the right words, but in short, hopefully this makes sense I have a power bi desktop installed, and its current version 2.114.864.0. 64 bit I have an existing SSRS/Power BI server setup and has existing reports with Data sources, I confirmed I do have full priviledge to the URL of the SSRS/Power BI and I made 5 data sources... What I dont know is that if Power BI can import or use Existing Data sources to connect to the SQL server? Similar to SSRS and Data sources, but can power bi do that as well? if so how?? steps please I am new to power bi. thanks in advanceMay 2022 version PBIRS changing datasource issue
Hi, we just updated our version and we are now having an error when we promote a report to an environment that has this new version. Power bi reports are not embedding credentials and not changing the connection strings anymore after the version got updated to May 2022. Anyone here know what's going on? this is our first update in 2 years now.. we are getting this error on our deploy: and this on the catalog logs: |ERROR|108|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.CatalogItemContentInvalidException: , Microsoft.ReportingServices.Diagnostics.Utilities.CatalogItemContentInvalidException: The item 'Connection strings for reports created with October 2020 or newer with enhanced metadata can only update Live connections. Prior versions can update Live and Direct Query connections.' contains invalid content.;| RequestID = s_6c34a7ae-755e-443d-b09c-d59a0fd8aa25
programatically Modify power bi dataset connections on Post OCT 2020 release - Parameters required?
We need to modify all power bi sharepoint datasources to modify the url in the connection string. I found this link describing how https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis The method on that page is to create parameterized connections; which, I think would require manual modification of all existing reports. Also, on that page: It says This is also a breaking change on how you could set this up in previous releases. If you're using a pre-October 2020 version of Power BI Report Server, see Change data source connection strings in Power BI reports with PowerShell - Power BI Report Server pre-October 2020 Question: If we are on post Oct 2020, are parameters the only way? I attempted the Pre OCt 2020 method and have been unable to get it to work (explaination in this question) https://community.powerbi.com/t5/Report-Server/ReportingServicesTools-Set-RsRestItemDataSource-BAD-REQUEST-how/m-p/2544542#M24355
Replace custom SQL datasource with dataflow
l have apublished report that uses a custom SQL as its datasource. I created a dataflow using the M-code version of that SQL. It is published, refreshes, etc with no issues. Now I want to take a few existing reports that use this SQL as the main datasource, and convert them to use the dataflow I have created. I have searched these forums and elsewhere but am unable to find a solution to this particular question. I was able to make a new datasource in the report using the dataflow. But this report has many VIZ (30+) and I don't want to recreate them all using the new dataflow datasource. Is there a way to either (1) modify the SQL datasource by replacing the custom SQL with the new dataflow, or tell Power BI to use the dataflow instead of the SQL datasource (I would then delete the SQL from the datasource list)? Thanks in advance for any help this community can provide"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.Can't edit datasource in PBIRS with custom authentication
Hi all, I have set up a server with PBIRS Jan2020 and custom authentication following the github pages indications. I can connect to the server using the forms authentication and everything seems to work fine. Main problem comes when i upload a PBI Report to the server with a SSAS live connection, i can't edit the datasource in the management tab of the report, the option datasource is disabled so i can't change the user and password to connect to ssas. On the other hands, with default windows authentication works without any issue. I tried uploading the report with the PBI Desktop > Save As > Report Server option and uploading manually the report to the server and in both cases i can't edit the datasource. In the server logs i found this line: Failed to get connection string for model | RequestID = 29a6f4bd-a6ce-28a6-0b07-59a3380b4db6 ClientSessionID = 35485d15-aa30-e08e-e29b-af7bb15732c1 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model Any clues? Thanks and regards
