power bi reports server
10 TopicsAzure SQL OAUTH || Power BI Dataflows
Hi, I need to connect to a Azure SQL db via Oauth. This is, according to https://docs.microsoft.com/de-de/power-bi/report-server/data-sources#list-of-supported-authentication-methods-for-directquery not possible. edit: currently no solution.... I tried setting up a Power BI Dataflow on one of my premium workspaces, but Power BI RS does not identify the source. Is there anyway I can refresh the data via Power BI RS and using Azure SQL db? Why can't I connect to Dataflows via Power BI RS? thank you very much!Solved2.6KViews0likes6CommentsPower BI report server configuration error
I have recently installed a Power BI report server, While I am configuring Database in Report server Configuration Manager I get the following error: Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation. ---> System.Runtime.InteropServices.COMException: The RPC server is not listening. (Exception from HRESULT: 0x800706B3) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo) at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script) From SSMS I can connect to the SQL server and create a database. Any help in fixing this issue is appreciated. Thanks12KViews0likes6CommentsDynamic RLS for on-premises Power Bi reports server
I`m new with Power BI and I apologize from the beginning if this topic has been discussed. Can you please let me know if Dynamic RLS is available for on-premises Power Bi reports server? Following this tutorial i`m not able to apply RLS over a datasets (no datasets present) because this option is not available after i saved the Report to Power BI Report Server from Power BI Desktop ( August ) If this tool is not available for on-premises Power Bi reports server can you please let me know how can I provide access for a specific User, to custom data from a report( same as the above tutorial)? Thank you in advance. CataSolved10KViews1like6CommentsRestrict access data in Power BI Report Server with Microsoft Access database
Hello, I want to segregate data in Power BI report server. The database is an Access database. "User 1 can only view the Perimeter" , "User 2 can only view the Perimeter 2". I have seen some solutions in internet : - Row Level Security in cloud (report services) - Using username() in MS SQL Server but it doesn't work for Microsoft Access database in Power BI report server. Can you help me please ? Thanks in advance948Views0likes0CommentsCan't upload report to report server on Microsoft Windows Server 2012- This is a unique problem
I installed The latest version(March 2018) of Power BI Report Server(Evaluation) on my Production Server(2012 R2- Standard) and installed the Power BI Desktop optimized for Power Bi Report Server - March 2018 on my pc(Windows 10). When I attempt to upload a report to the server(2012 R2- Standard), I get this error "There was an error uploading your .pbix file. Verify that this file has not been corrupted and that the file extension matches the format of the file." There is no problem with the file since I am able to upload it to a local report server on my PC (Windows 10). This error only occurs while I am attempting to upload to the Power BI Report Server on my server(2012 R2- Standard). Any help? As suggested by another user on this forum, I have changed the service account in the report server configuration manager from virtual service account to network service but the problem persist.1.1KViews0likes0CommentsAn error occurred while attempting to save the report to Power BI Report Server
We installed Power BI Report Server (Octobet 2017) from Enterprise license with SA (we have an EA). The existing report server was SQL Server 2014 Enterprise with many rdl files loaded. The Report Server was upgraded first while SQL Server 2014 Enterprise database engine was not upgraded. The reports ran fine but we never tested Power BI Reports. After upgrading the database engine, SSAS and SSIS to 2017 Enterprise, the first Power BI report we tried to save got the following error: An error occurred while attempting to save the report to Power BI Report Server. (close and cancel buttons) The report is saved on the portal and can run on the portal if the data was imported. If a new Power BI report has a live connection to SSAS, no data is displayed. The service is being run by an AD account that has local admin on the server. No virtual account or NETWORK SERVICE account is being used. here are some log file: RSManagement_yyy_mm_dd_hh_dd_ss.log 2018-03-20 08:53:39.1643|ERROR|13|One or more errors occurred.| RequestID = s_6c234c92-31b5-4a81-a174-f721f2905a42 2018-03-20 08:53:49.2080|ERROR|6|One or more errors occurred.| RequestID = s_f0e96508-f53f-4a92-a2cd-fe9a88a56b8d 2018-03-20 08:53:59.2547|ERROR|18|One or more errors occurred.| RequestID = s_88d77243-0a06-4d9d-beda-687130cbb993 2018-03-20 08:54:09.2984|ERROR|5|One or more errors occurred.| RequestID = s_0ac936da-c7f8-4774-90a9-e13cd107aed6 2018-03-20 08:54:19.3501|ERROR|6|One or more errors occurred.| RequestID = s_c0a71b9f-b928-4f61-ae42-7d8eb1921838 2018-03-20 08:54:29.3948|ERROR|7|One or more errors occurred.| RequestID = s_93b7f9ca-75ee-4b9e-b2cf-a347a425cd3c 2018-03-20 08:54:39.4436|ERROR|5|One or more errors occurred.| RequestID = s_aa56adff-bb1f-40fe-9649-8b3c733ea6a4 2018-03-20 08:54:49.4863|ERROR|14|One or more errors occurred.| RequestID = s_163ac7d8-d7bd-426b-b166-201805170293 2018-03-20 08:54:59.5350|ERROR|7|One or more errors occurred.| RequestID = s_03b24338-6c33-4ffc-b328-28fef2f304cf 2018-03-20 08:55:09.5797|ERROR|13|One or more errors occurred.| RequestID = s_deb6afa8-b16f-4a13-9f8f-d264b85140aa 2018-03-20 08:55:19.6254|ERROR|7|One or more errors occurred.| RequestID = s_798b82c8-aaa9-4a57-8bcf-27a7ed030a2d 2018-03-20 08:55:29.6691|ERROR|5|One or more errors occurred.| RequestID = s_f506acd5-7217-487f-9337-b7657653a933 RSPowerBI_yyy_mm_dd_hh_mm_ss.log 2018-03-20 08:05:14.1186|INFO|4|Started clean up of embedded models 2018-03-20 08:05:14.1186|INFO|4|Finished clean up of 0 embedded models 2018-03-20 08:20:14.1322|INFO|4|Started clean up of embedded models 2018-03-20 08:20:14.1322|INFO|4|Finished clean up of 0 embedded models 2018-03-20 08:35:14.1457|INFO|17|Started clean up of embedded models 2018-03-20 08:35:14.1457|INFO|17|Finished clean up of 0 embedded models 2018-03-20 08:47:34.8125|INFO|12|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_b7223224-7dbd-4760-8241-ad5a3730da53 2018-03-20 08:47:34.8125|INFO|12|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:38.1647|INFO|14|Sending response. Response code DOMAIN\sadmin 200, Elapsed time 0:00:03.3529771| RequestID = s_b7223224-7dbd-4760-8241-ad5a3730da53 2018-03-20 08:47:52.0224|INFO|8|Received request GET /| RequestID = s_3e12d0d8-8aa1-4d60-ac38-52643cc5a3d6 2018-03-20 08:47:53.8252|INFO|8|Received request GET /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/modelsAndExploration| RequestID = 96d05d7c-e103-f8ee-a811-364685c999c5 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:53.8252|INFO|8|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:57.6018|INFO|14|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:57.6018|INFO|14|CFG : EnablePowerBIReportExportData = [True] (env) 2018-03-20 08:47:57.6330|INFO|17|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:03.810953| RequestID = 96d05d7c-e103-f8ee-a811-364685c999c5 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:57.6957|INFO|8|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/conceptualschema| RequestID = bc6b3e5d-271c-4090-4a49-733f9050b01b ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:57.6957|INFO|8|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:58.9163|INFO|4|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:01.2335013| RequestID = bc6b3e5d-271c-4090-4a49-733f9050b01b ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.0441|INFO|18|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/querydata| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.0441|INFO|18|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:59.0441|INFO|8|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/querydata| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.0441|INFO|8|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:59.0441|INFO|12|Received request POST /api/explore/reports/291522a3-fd64-4ef9-ab4f-0ae2b6859f8b/querydata| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.0441|INFO|12|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:47:59.2687|INFO|19|PBI.DS.HostTrace|type:Information;message:Generating DataShape for: D2021183B2EA5DC34D5CBE97B8CA47D0BB71801F07293D198FADEB2E4345D3EE;| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.2843|INFO|14|PBI.DS.HostTrace|type:Information;message:Generating DataShape for: 303715754C0CB3A08E2C917A5CBB8E3773A736A554065A8BD18690F0E7BBCB85;| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.2843|INFO|5|PBI.DS.HostTrace|type:Information;message:Generating DataShape for: D43658CC071B91F15536072E102E09FFD900F750B073C4321F246A5E259B0138;| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.3000|INFO|19|PBI.DS.HostTrace|type:Information;message:DSQGen Telemetry: {"NumSelects":1};| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.3000|INFO|14|PBI.DS.HostTrace|type:Information;message:DSQGen Telemetry: {"NumSelects":1};| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.3000|INFO|5|PBI.DS.HostTrace|type:Information;message:DSQGen Telemetry: {"NumSelects":3};| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.3625|INFO|14|PBI.DS.HostTrace|type:Information;message:QueryPattern: SuperDax;| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.3937|INFO|19|PBI.DS.HostTrace|type:Information;message:QueryPattern: SuperDax;| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.3937|INFO|5|PBI.DS.HostTrace|type:Information;message:QueryPattern: SuperDax;| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.6437|INFO|5|PBI.DS.HostTrace|type:Information;message:Running the query. Memory Limit=0, Timeout=0, RequestPriority=Normal, ConnectionCategory=External, Query=6E239A294E07E8E174E6B64891A70E90E4301A667BF76CBA2A8DE50BFC368287;| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.6437|INFO|19|PBI.DS.HostTrace|type:Information;message:Running the query. Memory Limit=0, Timeout=0, RequestPriority=Normal, ConnectionCategory=External, Query=DAA00E93F4B283A2A4273016FC80A112D2A20D6074739E86F3ADACC98975C289;| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.6437|INFO|14|PBI.DS.HostTrace|type:Information;message:Running the query. Memory Limit=0, Timeout=0, RequestPriority=Normal, ConnectionCategory=External, Query=B6062D1A63EBBDABEDC90CE92EA7880D0BD5AD594ECD068C4CF5273BF307BDC5;| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.8000|INFO|5|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:00.7445504| RequestID = 8e983200-cf01-7207-20c7-a24d49a0290a ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.8000|INFO|5|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:00.7593658| RequestID = f76d2547-6444-c30c-d48e-22fe78a3ded0 ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:47:59.8000|INFO|15|Sending response. Response code domain\tadmin 200, Elapsed time 0:00:00.7468726| RequestID = dedd4dc9-6f55-aea1-fb7c-c495b354ddbb ClientSessionID = 866167a0-ba65-9ec3-44d3-730ffa027703 2018-03-20 08:50:14.1659|INFO|17|Started clean up of embedded models 2018-03-20 08:50:14.1899|INFO|17|Finished clean up of 0 embedded models 2018-03-20 08:50:19.3613|INFO|31|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_08795e4e-57aa-4112-acad-a145889de0f7 2018-03-20 08:50:19.3613|INFO|31|CFG : EnableCustomVisuals = [True] (env) 2018-03-20 08:50:22.5975|INFO|32|Sending response. Response code domain\sqluser 200, Elapsed time 0:00:03.2358909| RequestID = s_08795e4e-57aa-4112-acad-a145889de0f72.5KViews1like0CommentsText and setting icon color in power bi
how i can gave the different color to the text in small title bar mean the color of favorites or browse and the colorof icons on the main title bar like setting icon etc because when i changed the color of text in the small title bar the color of icons absorbs the same color can i change it using branding package. In the given image when i changed the color of text(browse) the color of setting icon will be changed with same color i want different color of setting icon using branding package.1.9KViews0likes1CommentNo folder content when connecting to PBIRS with Win APP
Hi, I have a PBI Report Server running (2017). I can publish normal reports and PBI reports to the server and everything can be viewed in a browser. When I connect to the server from the Windows PBI App I can see the folder structure but all folders are empty :-( Anyone else have this problem? BR Nicolaj1.4KViews0likes2CommentsEmbed power BI reports from Report server in a web application
Is it Possible to embed reports from Power Bi report services in a web application to be seen by external internet users (not authenticated)? is the IFRAME could be used for this (or they have to be authenticated users)? ThanksSolved3.7KViews0likes1Comment