Datasource offline
Hi All, I have notice one of our cloud datasource is offline, it was working fine from past 4 months and now suddenly its offline, I have create a new datasource connecting to same schema and database with same settings but want to find a way to bring the problematic datasource online again, any suggestion? I am pasting the error message as well with screen shots of the settings.
Power Bi data source connection for paginated report
I have paginated report using Azure SQL database. We have created report using the stored proc and published the report. The user who created the report and published left the project and I have taken the owner ship and tried updating the credentials. but it not working i have checked those are same credentials perviously used as well but i am unable to establish the connection to the datasource getting below message while connecting. I am using below connection method. Please provide your suggestion this problem. regards, Rajesh
"Datasource XXXXXX Not Found" PowerBI Refresh issues
Hi community! After installation of the Release May 2021 the error for the "Datasource XXXXXX Not Found" PowerBI Refresh issues are gone for the primary node of a Scale out Deployment. But for the second member the same error exists. The primary node in our landscape hosts the portal and the secondary node has the role "IsDataModelRefreshService". In both config.json the new setting "Hosting-databaseValidationStatus" is available. Does anyone have the same problems? Is there a special setting needed for the second scaleout member?
Credentials not working on direct query
Hi, I am using PBIRS version May 2020 on premise, and already published pbix source files into report server. Currently, we managed to use domain AD username for setting data sources in report server. Unfortunately, the credential works fine for pbix files with import-mode, not the ones with direct query..even, the network team has ensured to type password correctly. Can Microsoft/anyone please suggest to me what to do? Thank you,
How to change the data source of a model and run the existing queries?
I created a model based on excel file. after connecting to the data source (which is the his excel file) I created several steps and measures. Now I realized that it could be better to used a pivot table (which is in anotehr excel file) as a data source, instead of the first excel file. The layout is the same in both excel file and pivot table file (1st and 2nd file). When I change the data source to the pivot table excel file, it gives me error and I cannot connect it properly nor use the steps that I created beforehand. Error presented when trying to load new data source: "The key don't match any rows in the table". How to make that? Thanks, Diego"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.ERROR: Failed to get connection string for model in Reports Server
Hi, we have an interesting error with a specific PBIX. When a user tries to open this PBIX in most of cases it goes fine, but sometimes the user gets an error which points out the lack of permissions to open the report and the RS logs this error message below. User retries and in 1 minute later everything goes fine again. 2020-03-31 10:18:46.2747|ERROR|61|Failed to get connection string for model | RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model 2020-03-31 10:18:46.2747|ERROR|107|GetDataSource ERROR for catalogItem=6fd6e1dd-16f4-4f56-a5af-86885488ca1f, Exception=Failed to get connection string for model , ElapsedMs=56| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 2020-03-31 10:18:46.2747|INFO|107|Attempting to re-stream the model 6fd6e1dd-16f4-4f56-a5af-86885488ca1f for request 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb, session a6a9005d-6395-fa0c-fc5e-095a286c1f65| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 2020-03-31 10:18:46.5248|ERROR|145|Failed to get connection string for model | RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model 2020-03-31 10:18:46.5248|ERROR|80|GetDataSource ERROR for catalogItem=6fd6e1dd-16f4-4f56-a5af-86885488ca1f, Exception=Failed to get connection string for model , ElapsedMs=45| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 2020-03-31 10:18:46.5248|ERROR|57|Failure in conceptualschema| RequestID = 2c77d9a0-4f1b-2392-4e34-46eb1d3317eb ClientSessionID = a6a9005d-6395-fa0c-fc5e-095a286c1f65 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to get connection string for model at Microsoft.PowerBI.ReportServer.WebApi.ASConnection.RSDataSourceProvider.GetDataSource(Int64 modelId) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewDataSourceProvider.GetDataSourceInfo(String modelIdFromClient, RSDataSourceConnection& rsDataSourceConnection, IASConnectionInfo& asConnectionInfo) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.CreateModelKeyFromId(String modelIdFromClient, String maxModelMetadataVersion) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.EnsureSession(String modelId) at Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.<RunAsync>b__8_0() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ExploreHost.ExploreClient.<GetClientConceptualSchemaAsync>d__13.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.ExploreHost.RSExploreHost.<GetConceptualSchemaAsync>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetConceptualSchemaAsync>d__21.MoveNext() The Datasource of this PBIX refers to two SQL relational DB and an Excel file. DataSource1: Conn.Type: SQL | Conn.String: skrbipsql;START_TAR_DWH | Auth.Type: Windows Authentication DataSource2: Conn.Type: File | Conn.String: \\krtbidw\napi\kosz\2019-2020 kösz 8 mell. 9 b függelék.xlsx | Auth.Type: Windows Authentication DataSource3: Conn.Type: SQL | Conn.String: skrtarbipsql;DM_TMEN | Auth.Type: Windows Authentication Is it possible that the Report Server "doesn't like" this combination of DataSource declarations, or it seems to be a bug, or what? Any suggestions? Thanks, NSz.
