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!
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)
Datset updates - Power BI report does not
For the past week I have been having issues with my Power BI Report. I have a Power BI Report that is shared with many users. I frequently makes changes in the desktop version and the re-publish and thereby overwrite the report. For the past week I have been getting this mistake when publishing "publishing is complete. However we couldn't refresh your dataset". However my dataset does update but the report visuals does not. Any edits (adding visuals, renaming pages etc.) in the report are not showing in the Power BI service. I don't want to delete the report and re-publish the report (which solves the issue) as I will have to re-share with all people I've manually made it available to, dashboard using the report will break etc. Any ideas how to fix this? It feels like when I publish something has happened and the report is simply not updating. I have cleared all browser caches etc. so this is not related to local caching.Question on data limitation
I am in the beginning process of developling a data governance process at work. Does it make sense to require everyone who publishes a report to go through the PowerBI pipeline deployment process? I am skeptical because we currently already have an ecosystem of 140 workspaces. About 20% currently use the pipeline deployment process. If we create a governance that requires everyone to go through the pipeline deployment process, this would result in 300+ workspaces. My concerns are does this become to monstrous to manage? What is the best practice? and will I run into data storage issues? I know premium capacity allows us to have up to 100TB worth of data. The 1000 dataset limitation also scares me. What does this mean for pipeline deployment?
Request canceled: Blocked due to exceeding usage of resource 'ATCPU' in namespace 'VSID'
We have a core report we use as a Power BI Core Dataset. It has several queries some to an on-premise MSSQL Server, some to an Azure Database and some to Azure DevOps directly. We have our report scheduled for refersh every 4 hours. We at times (today in question every scheduled refresh has failed) are getting an error when the Dataset refreshes: The request has been canceled: Request was blocked due to exceeding usage of resource 'ATCPU' in namespace 'VSID'. The exceptionCulprit is one of the queries that is hitting Azure DevOps directly through an Analytics View. Is there any way to increase this limit? The report should be confgured to refresh one query at a time. Again this does not happen all the time, but often enough to ask the question what can I do to stop this from occuring.No Fields in Dataset
Hello, I've connected my Report Builder to a Dataset in my premium workspace. It is listed as a data source. The Table Wizard requires connection to a Dataset, so when I try to make a dataset out of this source it doesn't give me any fields to pick from. It's like the data source has no fields at all. I loaded this to PBI Service from PBI Desktop where I've made various reports with it. Any idea why I can't get the fields to show up?
