OData authentication to Power BI Report Server shared dataset
Hello everyone, We're trying to create reports using the same dataset so we can reuse them e don't use a lot o space replicating Power BI Reports. So, we create a datasource and a dataset using Report Builder. So far we have been able to make everything work. The only way that we could find to create Power BI Reports using this dataset, is using OData Feed (according to PBI doc and some posts in this community). So, I created the report using the URL http://powerbi/reports/api/v2.0/DataSets(dataset-id)/data and could get the data successfully. After I published the report to the Report Server, I could open and view the visualizations. But when I try to update the data (through update button or schedule refresh) it won't work. When I go to credentials and try to connect using the same credentials used in Power BI Desktop (while creating the report) it won't connect and give the message "Log on failed. Ensure the user name and password are correct." Can you anyone help me understanding what am I missing? Thank you in advance!
Este informe no ha podido tener acceso al Origen de Datos. Pongase en contacto con soporte.
Buenos dias, Estimados luego de la ultima actualizacion que estuvo Power Bi. no podemo agregar usuario al nuestro oriden de datos o DataSet. este no me permite guardar cuando agrego un nuevo usaurio para que pueda visualizar los reportes. anexo imagen.
Unable to have Scheduale refresh
Our organization is having some issues with our dataset not refreshing. We get the following message: xxx has failed to 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. <ccon>DataSource.Error: <ccon>Microsoft SQL</ccon>: <ccon>"User does not have permission on table incident. Line:317, Position:10" RequestId: TDS;e9f194a2-a354-45e9-afa6-bbb94c69e71f;10 Time: 2023-09-05T08:32:02.5471599Z</ccon>. DataSourceKind = <ccon>CommonDataService</ccon>. DataSourcePath = <ccon>econa.crm4.dynamics.com</ccon>. Message = <ccon>"User does not have permission on table incident. Line:317, Position:10" RequestId: TDS;e9f194a2-a354-45e9-afa6-bbb94c69e71f;10 Time: 2023-09-05T08:32:02.5471599Z</ccon>. ErrorCode = <ccon>-2146232060</ccon>. Number = <ccon>40000</ccon>. Class = <ccon>16</ccon>. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: incident. How do we fix this issue? (Please explain in a way someone who isnt proficcient in Power BI yet would understand)Scheduled Refresh of Report on Locally Hosted Report Server
I am trying to host a report and get it to update daily with new data. Right now, I have all of the data on the PowerBI service as dataflows or under a dataset. When I use these data sources (which are already updating daily), within my report PBIX file, and I upload it onto the web URL for others to view, I cannot schedule a refresh for that report. It says I don't have any external data connections defines or am using an unsupported data source. I have several API queries making up all of my data. Need to figure out how to get these refreshing all the way through to the report on the host server every night. Is this possible? How do I get this flowing properly?
Refreshing Data from Power BI Custom Visual Source Code
Hello, I currently have a use case where I need to refresh the Power BI Report Dataset through my Power BI Custom Visual source code on certain events. I know it is possible to refresh the dataset using host.refreshHostData(). However, this is a restricted API and it looks like it is necessary to upload the visual on AppSource for the API to work well. Unfortunately, we do not plan to upload our visual on AppSource. Is it possible to get access to the refreshHostData API without uploading it on AppSource? If not, then are there any other alternatives like LogicApps or Power Automate using a trigger event sent through the custom visual?
