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!
Lineage view for dataflow-dataset in different workspaces
If you implement a dataset that uses a dataflow as datasource and they are in differente workspaces, lineage will show all dependecies between them only if you set lineage view from dataset >> dataflow. If you set lineage view from dataflow, it will not show the datasets that denpends on this dataflow if dataset is in different workspace. My idea is no matter if dataset/dataflow are at the same or at different workspaces, lineage would show all dependencies. Motivation If you follow Power BI best practices for Workspace, Dataflow and Dataset you will end up having datasets allocated in different workspace as its dataflow source. In this situation it is important to know which are the datasets that use some specific dataflow as datasource, specially to manage update schedule, access permissions.
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?
