Login username and password prompt for Power BI report web portal URL and SSMS Reporting Services
Hi Team, Issue: Username and Password prompt for Power BI report webportal URL Issue: Using SSMS connect to Reporting Services URL endpoint Windows Authetication - errors. I installed Power BI Report Server on-premise build 15.0.1105.230 and SQL Server 2019 on the same VM. 1. Authentication type within Report Server config. <AuthenticationTypes> <RSWindowsNegotiate/> <RSWindowsNTLM/> </AuthenticationTypes> 2. SPNs for the report server service account for both the FQDN and NetBIOS using a virtual URL of RSSBX Setspn -a HTTP/RSSBX.co.com DOMAIN\RSService Setspn -a HTTP/RSSBX DOMAIN\RSService 3. SPNs for the SQL server service account for a instance name setspn -s MSSQLSvc/myhost.co.com DOMAIN\SQLServiceAccount setspn -s MSSQLSvc/myhost.co.com:instancename DOMAIN\SQLServiceAccount setspn -s MSSQLSvc/myhost:port DOMAIN\SQLServiceAccount setspn -s MSSQLSvc/myhost:instancename DOMAIN\SQLServiceAccount I've verified that the SPNs are setup properly. When I access the web portal from the Power BI Report Server VM itself or from a workstation using IE, Edge or Chrome browsers, it prompt for username/password. I use SSMS to connect to the Reporting Services with Windows Authentication, I get this error. I worked with Basic Authentication. Really appreciate any help!
how to get list of dataset and datasources using Power BI report server rest API?
Hi, I'm trying to get data from power BI report server through rest API, I can get list of kpi, catalog items and so on. I have attached my data sources image and and slo my report server home image But I'm not be able to get the data sets and data sources. When I call the following url I'm getting the empty array. { "@odata.context":"http://<server_name>/Reports/api/v2.0/$metadata#DataSources","value":[ ] }
Error token Power BI server with Power Automate
Hey guys. I have a report developed on the power bi server, where I put the power automate button to export the selected data. With that, I published the report, it turns out that in the link (online) the automation does not work and in the BI Server program on the machine it works. When looking deeper I noticed that it is giving an error in the Reques URL in the creation of the Flow token. The automation itself is working perfectly, only after the report sent to the online server did not work. Please if anyone has gone through something like that, let me know.why parameter definitions is not showing for shared dataset in power BI report server
Hi, When I'm calling the API for getting parameter definitions I'm getting an empty array, http://ServerName//reports/api/v2.0/Datasets(dataset_id)/parameterDefinitions { "@odata.context": "http://servername/reports/api/v2.0/$metadata#ParameterDefinitions", "value": [] } But I've set the parameters in the shared dataset How to resolve it Thanks in advance.
SSL Cert to Power BI Reporting Server Error Finding Cert
Per guide https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-ssl-connections-on-a-native-mode-report-server?view=sql-server-ver15 I try to add Verisign wildcard cert to the Power BI Reporting Server local certificate store both in Trusted Root and ICA but the Report Server Configuration Manager don't show the cert under Web Service URL as a option. Made sure stop and restart Power BI service but still don't show up. Putting cert in wrong folder or Power BI Report Server don't support Verisign cert?how to get data from shared dataset inside folder using power BI rest API?
Hi, I'm trying to get data from a dataset inside folder using rest API. http://d2n3kzl2//reports/api/v2.0/folders(dataset id)/catalogitems By using the above url I getting the following items { "@odata.context":"http://<server name>/reports/api/v2.0/$metadata#CatalogItems","value":[ { "@odata.type":"#Model.DataSet","Id":"dataset ID","Name":"forGinieDataset","Description":null,"Path":"/forGinie/forGinieDataset","Type":"DataSet","Hidden":false,"Size":3000,"ModifiedBy":"D2N3KZL2\\GainAdmin","ModifiedDate":"2019-12-02T13:41:54.82+05:30","CreatedBy":"D2N3KZL2\\GainAdmin","CreatedDate":"2019-12-02T12:30:13.137+05:30","ParentFolderId":"217f25cd-4770-4e4f-a870-64e514d44d7f","IsFavorite":false,"Roles":[ ],"ContentType":null,"Content":"","HasParameters":false,"QueryExecutionTimeOut":0 },{ "@odata.type":"#Model.DataSet","Id":"dataset ID","Name":"forGinieDataset1","Description":null,"Path":"/forGinie/forGinieDataset1","Type":"DataSet","Hidden":false,"Size":973,"ModifiedBy":"D2N3KZL2\\GainAdmin","ModifiedDate":"2019-12-02T13:42:07.707+05:30","CreatedBy":"D2N3KZL2\\GainAdmin","CreatedDate":"2019-12-02T12:35:43.227+05:30","ParentFolderId":"217f25cd-4770-4e4f-a870-64e514d44d7f","IsFavorite":false,"Roles":[ ],"ContentType":null,"Content":"","HasParameters":false,"QueryExecutionTimeOut":0 },{ "@odata.type":"#Model.Report","Id":"dataset ID","Name":"Report1","Description":null,"Path":"/forGinie/Report1","Type":"Report","Hidden":false,"Size":14792,"ModifiedBy":"D2N3KZL2\\GainAdmin","ModifiedDate":"2019-12-02T12:35:43.583+05:30","CreatedBy":"D2N3KZL2\\GainAdmin","CreatedDate":"2019-12-02T12:30:15.663+05:30","ParentFolderId":"217f25cd-4770-4e4f-a870-64e514d44d7f","IsFavorite":false,"Roles":[ ],"ContentType":null,"Content":"","HasDataSources":true,"HasSharedDataSets":true,"HasParameters":false } ] } When I'm trying to get the data sets inside the folder with the following URL http://d2n3kzl2//reports/api/v2.0/folders(folder ID)/catalogitems/Model.DataSet I'm getting the available datasets in side the folder How can I get the data from the data set inside the folder?Get the data from dataset by passing parameters to Stored procedures?
Hi, I'm trying to get data from the shared dataset by passing parameters and I'm calling stored procedures through the dataset. When I'm trying the access the data from the dataset using parameters I'm getting the following error, The value for parameter 'ItemPath' is not specified. It is either missing from the function call, or it is set to null. The following is my stored procedure is MSSQL CREATE PROCEDURE TEST_PROCDURE (@ProductName as VARCHAR(100),@BrandName as VARCHAR(100),@StoreName VARCHAR(100),@CityName VARCHAR(100)) AS BEGIN if ((@ProductName IS NOT NULL) AND (@BrandName IS NULL) AND (@StoreName IS NULL) AND (@CityName IS NULL)) BEGIN select PRD.PRODUCT_NAME,sum(PRD.LIST_PRICE) from BikeStores.production.products PRD where PRD.PRODUCT_NAME = @ProductName group by PRD.PRODUCT_NAME END else if ((@ProductName IS NULL) AND (@BrandName IS NOT NULL) AND (@StoreName IS NULL) AND (@CityName IS NULL)) begin select BRND.brand_name,sum(OITM.list_price) from BikeStores.production.brands BRND join BikeStores.production.products PRD on BRND.brand_id = PRD.brand_id join BikeStores.sales.order_items OITM on PRD.product_id = OITM.product_id where BRND.brand_name = @BrandName group by BRND.brand_name end else if ((@ProductName IS NULL) AND (@BrandName IS NULL) AND (@StoreName IS NOT NULL) AND (@CityName IS NULL)) begin select STS.store_name,sum(OITM.list_price) from BikeStores.sales.stores STS join BikeStores.sales.orders ORD on STS.store_id = ORD.order_id join BikeStores.sales.order_items OITM on ORD.order_id = OITM.order_id where STS.store_name = @StoreName group by STS.store_name end else if ((@ProductName IS NULL) AND (@BrandName IS NULL) AND (@StoreName IS NULL) AND (@CityName IS NOT NULL)) begin select STS.city,sum(OITM.list_price) from BikeStores.sales.stores STS join BikeStores.sales.orders ORD on STS.store_id = ORD.order_id join BikeStores.sales.order_items OITM on ORD.order_id = OITM.order_id where STS.city = @CityName group by STS.city end END; Following is the screenshot my shared dataset and parameters. Following is the screen shot of calling it from postman
