Scheduled Refresh Fails, Manual Refresh Succeeds
I have a Semantic Model that utilizes 5 data sources. One of the data sources (connected to Amazon Redshift SQL) keeps triggering a failure message 3-5 minutes into the scheduled refresh (error at the bottom of post). When I go into the connection settings, I see the password is reduced down to 8 characters (this might just be a visual thing, but either way). I then put the password in, Save, and trigger a refresh on the server again. This refresh always works. I've also tried making a new connection and replacing he existing one - same error occurs. So either the data source can't support scheduled refreshes or the correct password won't save. Has this happened to anyone else out there? Any ideas how to restore the automation to my 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. [ValidateMarkupTags]<ccon>{"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":"[ccon][ccon]ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] connection to server at \"[SERVER STRING IS HERE]" ([ccon]<ip>52.26.233.171</ip>[/ccon]<ip><ip>52.26.0.0</ip></ip>), port 5439 failed: timeout expired\n[/ccon][/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AmazonRedshift"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon]etl-workgroup.774598924186.us-west-2.redshift-serverless.amazonaws.com;bswift[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.NativeError","detail":{"type":1,"value":"10"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.SQLState","detail":{"type":1,"value":"08S01"}}],"exceptionCulprit":1}}}</ccon>
Export entire report to pdf in Power BI Report Server (On-Prem)
Hi All, We had developed Power BI Reports in Report Server (On-Prem) and embedded those reports in our application. Problem is that we can not find option to export the entire report in pdf. E.g. below screenshot shows only print option that too it export only current page. Kindly guide use if we are missing any thing here. Thanks!
Models not supported in Power BI Report Server
Hello, I get the following error when I try to open one of our reports: "This file uses many-to-many relationships or a composite model which combines DirectQuery sources and/or imported data. These models aren't currently support in Power BI Report Server". However the report was created on the exact Power BI Desktop version that matches the server version (January 2021) and the report is currently running on the local server. Sooooooo... I know, it is an old server and desktop version and the solution is most likely to upgrade to more recent versions where this issue might have been fixed. I just wanted to add the information to the forum so that if anyone else encounters this problem, they know they are not alone 🙂
Power BI Server and Keyedin
I connected to Keydin on the Power BI desktop using the API. Authentication Type: Anonymous. As a result the report updates successfully. But after publishing, I got this message when I tried to test the connection. Maybe you have experience working with connection to Keyedin
Organizational account credentials from Power BI Server?
Hi, I've created a report with a Sharepoint Folder data source (specificaly, an excel xlsx file in a folder of my Sharepoint site). My Sharepoint is hosted on Sharepint Online and I access it via Organizational Credentials. I've been able to do it in Power BI Desktop for Report Server (October 2017). Once I publish my report to POwer BI Server, I go to "Manage > Data Source" , there in Credentials I can only choose Anoymous or WIndows Authentication. Is there a way to have a report pulling data from Sharepoint Online from Power BI Server as of now? (and have it refresh on a scheduled basis). THe idea is to have some select users edit data in the EXcel file, and management can open the report done in POwerBI. (I'd like to avoid having to open the report in PowerBI Desktop and republish it everytime there is a change in the data source, which is what I am doing for now.)
Find Power BI data sources for on premise server
How can I run a query (sql, powershell, or rest) to find all the data sources of my Power BI dashboards? Most the documentation is around using powershell but the soultions are all against the cloud Power BI service. I have a local/on premise Power BI server and I am trying to document the SQL server names and databases for each of the published dashboards. It would be helpful if it looped through all the dashboards in the sub folders so I don't have to manually add the indivdual dashboards.RDL file size limit for Report Server
This is specific for PowerBI Report server I have a RDL file size about 1.5 MB. when review few columns from the table tablix to reduce the size. I have no issue to deploy the report. but once the file size over 1.5MB. below error when trying to deploy Severity Code Description Project File Line Suppression State Error System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded. at System.Web.HttpRequest.GetEntireRawContent() at System.Web.HttpRequest.get_InputStream() at System.Web.Services.Protocols.SoapServerProtocol.Initialize() --- End of inner exception stack trace --- at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) 0 for older version Report server usually adding a config maxRequestLength will work Any suggestion for the latest version PowerBI report server
