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?
Error on datasource refresh
Has anyone seen this error before? It happens on datasource refresh. And don't specify where the error occurs... Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net ID da atividade: 20080bab-f27a-4079-9d65-decf90567a65 Solicitar ID: 4f8cfe56-0a7f-4d50-851b-d766ddbe604f Hora: 2023-03-27 13:44:44ZPower 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
