Erro de conexão Power BI e cPanel
Olá, Estou enfrentando um problema ao tentar carregar um modelo de dados no Power BI Service para publicar a dashboard em meu site. Durante o desenvolvimento, utilizei o Power BI Desktop e configurei a conexão ao meu banco de dados hospedado em um servidor acessível via cPanel. Para isso, fiz o seguinte: Mandei meu IP para o cPanel para liberar o acesso ao banco de dados. Baixei e configurei o ODBC na minha máquina para conseguir desenvolver a dashboard. Tudo funcionou perfeitamente no Power BI Desktop. No entanto, ao tentar publicar e carregar o modelo de dados no Power BI Service, recebo a seguinte mensagem de erro.
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.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!
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?
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 postmanwhy 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.how to get aggregated data from Power BI report server using Rest API?
Hi, I'm trying to get the aggregated result from POWER BI report server rest API by using the following url http://{server}//reports/api/v2.0/Datasets(23617073-a6d9-45e8-8f2c-abc78bdfb267)/Model.GetAggregatedValue?ColumnName=ingredient_name&Aggregation=6 I can able to retrieve data from the datasets The following are the parameters ColumnName - The name of the DataSet column to aggregate the value for.(I give dimension name here) Aggregation - The type of aggregation to use on the specified column. Values come from the KpiSharedDataItemAggregation enum.(for Aggregation they mentioned to use KpiSharedDataItemAggregation and I'm using 6 as value as per the documentation https://docs.microsoft.com/en-us/openspecs/sql_server_protocols/ms-rsrest/a7f68efc-4622-47be-949c-ed66ee8f57de if this is right? where can I mention measure) Parameters - An array of DataSet parameters to use when executing the query. Format for parameters { "Parameters": [ { "Name": "string", "Value": "string" } ] }(Hope this is used for filter if so, how can I give values)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?How to get aggregated values using Power BI report server rest API?
Hi, I'm trying to get aggredated value from the shared data using using the following API url. http://localhost/reports/api/v2.0/DataSets(dataset_id)/Model.GetAggregatedValue?ColumnName=ingredient_price&Aggregation=sum Nothing is working for me regarding Model. for example model.getdata is also not working http://localhost/reports/api/v2.0/DataSets(dataset id)/Model.GetData and I'm getting the error in attached image. what is Model? and for /dependentitems http://d2n3kzl2//reports/api/v2.0/DataSets(dataset id)/DependentItems I am getting the following error { "error":{ "code":"","message":"No HTTP resource was found that matches the request URI 'http://d2n3kzl2/reports/api/v2.0/DataSets(7af2bc9a-738d-47f9-a1da-2a182d0b8509)/DependentItems'." } } How to resolve this too? Thanks in Advancehow 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":[ ] }
