pbix
20 TopicsUnable to upload PBIX files
Hi there, We are getting the following error when trying to upload reports to our report server. It was at the January 2026 version and we tried to update it to May 2026 version to see if that resolved the issue, but we get the same message with the May version as well. We had previously been able to create reports in the January 2026 desktop version and upload them to the server okay and have also tried to create reports in May 2026 desktop version and upload but nothing seems to work. Our live server (January 2026 still) still works okay. We can upload PDFs or text files to the server okay. It just seems to throw the error when you try to upload a PBIX file. If i check the console when I try to upload any reports we get the following error: and have checked the server logs and get the follwoing polyfills-KEOJFKRO.js:1 POST https://XXXXXXXXX/Reports/api/v2.0/catalogitems 422 (Unprocessable Entity) (server address removed) We have tried googling those to see if there is a fix or known issue for that but can't really find any information on those 2 errors. We have checked the certificates on the server and they seem to be okay and have the correct binding. We are at a bit of a loss on how to resolve this - does anyone have any ideas? Thanks DeniseSolved983Views0likes4CommentsCan't export full .pbix + can't publish after live connection workaround
Can't export full .pbix + can't publish after live connection workaround Hi community, I've been running into a frustrating chain of issues over the past few days and wanted to see if anyone else is experiencing the same. Issue 1: Can no longer export .pbix with data I have reports that I've successfully downloaded as .pbix (full copy with data) many times before. Suddenly, I'm getting the error: "We couldn't export to .pbix format." The only download mode that works now is "A copy of the report with a live connection to the data online" — the full data export fails every time. For context: - The report was originally published from Power BI Desktop (not created in the Service) - Large dataset storage format is OFF - No incremental refresh configured - The tables are not large at all, so dataset size shouldn't be a factor - No deployment pipeline involved Issue 2: Can't publish after editing the live connection .pbix After making report edits in Desktop using the live connection file, I tried to publish back to the service and got this error: "An error occurred while attempting to publish 'Report Name.pbix': The remote server returned an error: (404) Not Found." My questions 1. Is anyone else suddenly unable to export full .pbix files from reports they previously could download without issues? 2. Is there a known issue with the UK South region affecting exports and publishing? 3. Any workaround to publish a live connection .pbix back to the service? Thanks in advance, any help or confirmation that others are seeing this would be really useful!475Views0likes2CommentsDAX Calculated Column Sequence of Event Actions and Sessions
I have dataset with users actions logs. We have next data collection logic - every user have it own user_id and we record log of event actions during user session. user_id session_id dateTime event 1 aa 2023-01-01 13:12:11 login 1 aa 2023-01-01 14:12:10 buy 1 bb 2023-01-02 11:12:10 page 2 cc 2023-01-01 10:11:01 login 2 gg 2023-01-03 11:12:11 logout 2 gg 2023-01-03 13:11:03 click 2 gg 2023-01-03 14:10:07 logout The main goal is prepare output and add 2 calculated columns: 1. with events action sequence during every user session and 2. with session sequence during all user lifetime by SQL. Expected output: user_id session_id dateTime event event_seq session_seq 1 aa 2023-01-01 13:12:11 login 1 1 1 aa 2023-01-01 14:12:10 buy 2 1 1 bb 2023-01-02 11:12:10 page 1 2 2 cc 2023-01-01 10:11:01 login 1 1 2 gg 2023-01-03 11:12:11 logout 1 2 2 gg 2023-01-03 13:11:03 click 2 2 2 gg 2023-01-03 14:10:07 logout 3 2 What was done from my side: 1. Successfully create column with events action sequence during session Event Action Sequence = COUNTROWS ( FILTER ( CALCULATETABLE ( Sheet1, ALLEXCEPT (Sheet1, Sheet1[session_id]) ), Sheet1[Date] < EARLIER ( Sheet1[Date] ) || ( Sheet1[Date] = EARLIER ( Sheet1[Date] ) && Sheet1[Time Action] <= EARLIER ( Sheet1[Time Action] ) ) ) ) 2. Sessions Sequence Order By each user - calculated column not prepared - I stucked on it. Only prepared time for each session when it started (minimum time for each session) Min Session DateTime = CALCULATE( MIN(Sheet1[dateTime]), ALLEXCEPT(Sheet1,Sheet1[session_id]) ) So the main help request, how to solve this and create one more column with sessions sequene number orderd ascending by timestamp for each user. Sharing link to my pbix file https://drive.google.com/file/d/1807l9E07oNJv9l5rKWXKxDoc6rniyiYG/view?usp=sharing And sharing link to my sample: https://docs.google.com/spreadsheets/d/1bb7VId8lJ-NQkF43YS739kfc5Ur-1cGy/edit?usp=sharing&ouid=103990807236416334574&rtpof=true&sd=true626Views0likes1Commentnot getting updated dataset when downloading data from powerbi reporting server
I have a dashboard that is updated as of yesterday but when i download the dashboard pbix file the data in that pbix file is old not updated as of yesterday. does anyone know how to get the updated pbix file directly from the reporting server. here is a snapshot757Views0likes1CommentImpossible to upload files .pbix bigger than 20MB
Hello, For a few days I can't upload the files bigger than 20MB. My last succeed upload was the 15/12/2021, I can't say what the root cause of my problem. The error is not clear, juste "Unexpected error. Try later". Can you help me ?Solved2KViews0likes5CommentsHow to recover a report from a backup copy of the report server database
I have a developer who was a bit aggressive when cleaning up some of his reports and accidentally deleted one off our report server. Unfortunately, no one can locate a copy of the .pbix file, so our only option to retrieve it is to pull it from a backup copy of the report server database, which we do have. I've read several different posts that are now a few years old explaining how to do this, but my attempts to follow those directions so far have all failed to produce a usable file. I assume this is because there have been some internal changes to the way the report definition is being stored in the report server database since those instructions were published. Could someone please provide a set of current steps for retrieving the .pbix file from a copy of the report server database? Thanks!Solved6KViews0likes6CommentsUnable to upload PBIX file to PBI Report server
Hi everyone I have problem with uploading PBIX file to report server May 2021. I have a fresh installation of PBI Report Server and old one on with I have made upgrade Januarry 2020 to May 2021. In both cases I'm not able to upload PBIX file. I can upload RDL and Excel file with no problems, but not PBI. I have created simple PBI file in May 2021 Desktop application. Software version PBI Reports Server Version1.11.7815.26414(May 2021) PBI Desktop Version: 2.93.1681.0 64-bit (maj 2021) Windows Serwer 2019 [Version 10.0.17763.2061] The error I'm getting is An error has occurred. There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file. I have checked log files and I see HTTP 422 error When I track web browser communication I also get error 422. Please help to resolve this.5.1KViews0likes9CommentsIs there a way to auto extract a template PBIT from a PBIX file or get a PBIT from the PBIRS API?
We are trying to use the Power BI on-prem API to Get all the reports and download them to a folder (we were able to POC this). Then we would like to extract the template file -or- remove all data from the files so we could check them into source control. Because these reports can be very large and contain very sensitive data, we need the data scrubbed from the files. Is there a way to do this?2.9KViews1like2CommentsPowerShell - deploy and Update PBIX on Report Server
Hello Community, I have used theses lines in order to deploy a pbix file on Report Server : $session = New-RsRestSession -ReportPortalUri http://lservername/Reports Write-RsRestCatalogItem -WebSession $session -Path "C:\2019\mypbix.pbix" -RsFolder "/MyFolder" It is working fine. Now, when I need to update the bix with another version , I used the same command bellow but I am getting this error : Write-RsRestCatalogItem : System.Exception: Failed to create catalog item: The remote server returned an error: (409) Conflict. ---> System.Net.WebException: The remote server returned an error: (409) Conflict. at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() --- End of inner exception stack trace --- At line:1 char:1 + Write-RsRestCatalogItem -WebSession $session -Path "C:\2019\PwC Acade ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-RsRestCatalogItem Does any one please have an idea about hte command PowerShell that could update apbix previously on the Server please by a new version ? Many thanks Best Regards, Asma2.9KViews0likes2CommentsCan a Report access a secure Dataset in a completely different workspace?
Hi, I am hoping this is the right forum for this question. I am presenting data to clients through Power BI. Due to the way the client wants to use the data they have requested the report is kept in their premium workspace to be able to pin out visual metrics to their various dashboards, however I would like to keep hold of and control of the data sets in our own Sharepoint. Due to the multiple data sources we have and way we create or manipulate the data it is important to me that the client cannot download or analyse the PBIX file at their end, only see the report. Is it possible for the report to be used in this way? Thank you627Views0likes1Comment