power bi rs
13 TopicsProblem with HTTPS on Power bi Report Server
Hi. I'm facing the following problem. Can someone help me to solve this? I configured the power bi report server to work with HTTPS (443 port) keeping the HTTP working too. When I access the URL like this http://urltopowerbireportingservices (HTTP:80), automatically is redirected correctly to https://urltopowerbireportingservices/Reports (HTTPS:443). However, if a access the URL like https://urltopowerbireportingservices (without /Reports), an error 404 occurred (see image 1). URL https://urltopowerbireportingservices/Reports (with /Reports) works perfectly. Image 1 - Error 404 when I access https://urltopowerbireportingservices The problem is that the URL https://urltopowerbireportingservices is not redirecting to https://urltopowerbireportingservices/Reports. How can I configure to make this work? Web Service URL configuration Web Portal URL configuration. The rsreportserver.config file is configured like this: IIS on server is disabled. Thanks.1.9KViews0likes1CommentOData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauthoriz
Hello Microsoft Support & community, After the installation of power bi report server (may 2023 version) the users are getting the error message "An error has occured. Try again later" on scheduling creation or modification on Power BI Report Server portal. (users have content manager profile on the directory where the reports are saved; they have also “system user” on security site parameters level) The error in the log RSPortal_2024_01_25… ==> 2024-01-25 11:10:45.7026|ERROR|19|OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol() at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetCacheRefreshPlanProperties(String cachRefreshPlanId, String description[] parameters) at Microsoft.ReportServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass1_0.<ExecuteWithCorrespondingAuthMechanism>b__0()..... When adding a user to the local admin group on the server (BUILTIN\Administrators) creating or modifiying scheduling works as expected. But the point is, we don't want to make every report developer/author server admin.) Thank you for your help.Solved3.6KViews0likes4CommentsFinding Unsupported features in Power Bi RS
* Power Bi Report Server is an offshoot of the SSRS report server, enhanced and optimized for hosting Power Bi reports. * The normal Power Bi Desktop created reports likely will not work with this due to having features not supported by the server. * Instead, you need to use a special version of desktop, commonly called Power Bi Desktop RS (version number/date) * You can save an existing Power BI report created in the normal desktop version by saving it as a template and opening it with the RS version. * But, there may still be some advanced features in the report that are not supported in Power Bi Report server and these will prevent the report from being uploaded to the server. Question: Is there an easy way to identify features in a PBi Report that are not supported by the Power Bi Report Server?1.9KViews0likes3CommentsPowerBI RS - Customise Tile View
By any chance Is there any way to customize the List View or create a custom List View for End Users? I would like to leave only the Name and Description. Is it something that can be done? If yes can you please advise? Thanks Brendon SpiteriSolved651Views0likes1CommentPower BI Responsiveness and Performance
Hello, We run a Power BI RS configuration on our domain. This setup was recently updated from the October 2020 build to May 2022. After the update the users have been reporting the following and I wanted to see if there was a way to improve the performance of Power BI. We cannot go to a pbix file and open it. We have to open the application first from the desktop, then use File --> Open. If we try to open a file directly, the PBI icon comes up and it hangs there. It takes several minutes for the PowerBI application to open from desktop. Once a pbix file is open, another one will not open. It starts to open--the PBI icon displays--but it never does open. Similar to bullet 1. This is whether or not we try opening the file directly or use the File menu. Closing a file works fine but we get a message a few minutes after closing that PowerBI has crashed. Power BI RS runs on a Windows Server 2016 VM. The VM has plenty of resources dedicated to it, the memory and CPU are never maxed out.919Views0likes2Commentsremove visual from Visualizations
Hi All, Is it possible to remove a visual from the Visualizations which is there by default in Desktop version? I am working with Power BI Rs and we would like to understand if this is possible or not...are the visuals stored as a file on the C drive and can be deleted? Thank you for the help in advance!Solved2.9KViews0likes3CommentsPower BI RS: error connection on SSAS with windows authentification
Hi, We have got an error when i want to connect with power bi report on SSAS datasource. The connection on SSAS is with authentification windows of connected user and i have this error : |ERROR|22|PBI.Win.DataExtensionException|ExceptionType:Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException;DataExtensionErrorDetails:Details: Message=Failed to open the MSOLAP connection., HResult=0x80004005, ErrorCode=OpenConnectionError, Language=en-US, ProviderErrorCode=0x00000000, ProviderErrorMessage=[7A59B7A8A1D3F5DFF802B686DA37E746230D73D342093788372E08D29F9BAF29], ProviderGenericMessage=[Error Code = 0x00000000, External Code = 0x00000000:.], ErrorSource=PowerBI, ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Could not initialize connection];stackTrace: à Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl() à Microsoft.PowerBI.DataExtension.Contracts.Utilities.RunSynchronously(Action action) When I forced the user authentification, the connection to SSAS is OK. Report Server and SSAS are on different server. Please, Can you help me?Solved6.7KViews0likes3CommentsConvert from imported data to direct query
I am using the May 2020 Power BI Desktop release optimized for Report Server. I want to convert a report from using imported data to direct query with Snowflake. I know that I can connect to Snowflake in a target report, set up the model, and then copy/paste visuals from the source report to target. But I'd rather just delete the imported tables in the source report and connect to snowflake from there. I have tried deleting all tables in the source so there is no data in the report. However, when I connect to Snowflake, the option for Direct Query is disabled. I have tried closing and reopening the report but still seeing the issue. There is something in the report that says the storage mode is import even though I have deleted all of the tables. Any ideas on a workaround?Solved1.3KViews0likes1CommentExcel access to on premise published power bi dataset
HI I know about the Power BI add in for excel and how to connect to dataset in cloud But is there any chance using this to connect to dataset published to on premise power bi report server ? And the option of connecting directly to the pbix file while powerbi desktop is open isnt an option here /m621Views0likes1Comment