power bi desktop
61 TopicsCan'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!490Views0likes2CommentsHow to create drill-down matrix hierarchy with pre-aggregated data without double-counting?
I have a pre-aggregated dataset from an agency where each hierarchy level has its own row with pre-calculated values: Category Total = 158,244 Sub-category = 45,000 Brand = 11,804 SKU = 350 The dataset also contains multiple periods (Q1, Q2, Q3, Q4, YTD, MAT) and regions — each combination of Product x Period x Region has its own row. Leaf nodes (SKU level) sum up correctly to parent values. What is the best approach to enable drill-down hierarchy in Power BI matrix with this data structure, without double-counting?Solved4.1KViews0likes6CommentsArranging pages in power bi desktop
Hi All, I have one concern about pages in power bi desktop. It is very hectic to re-arrange the pages. Suppose if we have 30 pages in our report. And we are on last page of report and we wanna move that page to 1st position. In order to do this we have to drag multiple times to bring that page to first position. Is there any other way to do so ? thanks in advance! Siddhant7.2KViews0likes3CommentsLocal update of BI takes seconds, update on Report Server takes hours
I'm having a lot of problems when scheduling the updates of a BI I made, we are taking data from Postgres and the total size for the report is around ~50mb, when I update the BI from my computer (using Power BI Desktop (May 2023)) it can take around 30 seconds to update everything, however, it constantly timeout on the Report Server, taking way longer than an hour, also, sometimes it gives me problems about cyclic references which do not appear locally. Is there anyway to fix these issues? Having to manually update the BI kinda defeats the purpose of scheduling the update, specially when I cannot trust it will actually update.627Views0likes1CommentError while connecting PostGres to Power BI
I'm trying to connect my Power BI Desktop to Post Gres SQL. I get the following error when I tried to connect. Details: "Loading assembly file 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'PostgreSQL'" With the same credentials, im able to connect to the MY SQL workbenchSolved4.1KViews0likes2CommentsOrganizational account credentials from Power BI Server?
Hi, I've created a report with a Sharepoint Folder data source (specificaly, an excel xlsx file in a folder of my Sharepoint site). My Sharepoint is hosted on Sharepint Online and I access it via Organizational Credentials. I've been able to do it in Power BI Desktop for Report Server (October 2017). Once I publish my report to POwer BI Server, I go to "Manage > Data Source" , there in Credentials I can only choose Anoymous or WIndows Authentication. Is there a way to have a report pulling data from Sharepoint Online from Power BI Server as of now? (and have it refresh on a scheduled basis). THe idea is to have some select users edit data in the EXcel file, and management can open the report done in POwerBI. (I'd like to avoid having to open the report in PowerBI Desktop and republish it everytime there is a change in the data source, which is what I am doing for now.)48KViews9likes35CommentsUnexpected Error Power BI report Server With Desktop While Connecting/Save As
I have configured the Power BI report server with custom authentication and I am able to browser reports and upload reports from Desktop version and optimised dektop version from the web url. But when I try to connect or save as to report server from the optimised desktop version (Jan 2019), I always the error "Unexpected error encountered". I have seen the log files and below is the error message(s). I am also getting the same error when I am trying to edit the report from browser and opening it in the optimised desktop version for power bi server. I am using the latest version of Power BI report server, desktop version and optimised desktop version. Can somebody please help me on this as I am really struggling to understand, why it is unathorised. 2019-05-22 00:11:35.4527|INFO|40|Sending response. Response code 401, Elapsed time 0:00:00.0001283| RequestID = s_6a077791-e4b6-4df6-b500-43388022ec3f 2019-05-22 00:11:51.3842|INFO|39|Received request GET | RequestID = s_bd226fee-61d0-4053-8cc6-57c312b2f743 2019-05-22 00:11:57.0293|INFO|40|Received request GET /api/v2.0/ServiceState| RequestID = s_dd68be34-263b-4cfa-990f-b02ccfc1814d 2019-05-22 00:11:57.0293|INFO|40|Sending response. Response code 401, Elapsed time 0:00:00.0001742| RequestID = s_dd68be34-263b-4cfa-990f-b02ccfc1814d 2019-05-22 00:11:57.2474|INFO|40|Received request GET /api/v2.0/ServiceState| RequestID = s_be9aeee1-19b2-4411-84e8-457d8f0e38fb 2019-05-22 00:11:57.2474|INFO|40|Sending response. Response code 401, Elapsed time 0:00:00.0001366| RequestID = s_be9aeee1-19b2-4411-84e8-457d8f0e38fb 2019-05-22 00:18:16.8672|INFO|42|Received request GET /api/v2.0/ServiceState| RequestID = s_0ef6cbe1-2aaa-4eef-bb5b-09d6e690b82c 2019-05-22 00:18:16.8672|INFO|42|Sending response. Response code 401, Elapsed time 0:00:00.0002326| RequestID = s_0ef6cbe1-2aaa-4eef-bb5b-09d6e690b82cSolved14KViews0likes7CommentsDynamic RLS with Hierarchy for Embedded Paginated Reports in Power BI Desktop
Hello Power BI Community, I hope this message finds you well. I am reaching out to seek your expertise and guidance on a challenge I am currently facing with implementing dynamic Row-Level Security (RLS) with Organizational Hierarchy in an embedded paginated report. I have successfully implemented dynamic Hierarchy RLS for standard Power BI reports. The RLS is designed to allow Level 1 employees to view only their data, Level 2 employees to see their data as well as the data of all employees at Level 1 reporting to them, and so forth. While this dynamic Hierarchy RLS is working seamlessly for Power BI reports, I have encountered an issue with embedded paginated reports. Example, Level 1 employees can see not only their own data but also the data of their peers at the same level. I would greatly appreciate any guidance or assistance from the community on resolving this issue. If anyone has experience resolving such challenges with embedded paginated reports in Power BI Desktop, your insights would be invaluable. Any suggestions, best practices, or troubleshooting tips to ensure that the RLS filters out data accurately, maintaining the hierarchical structure for embedded paginated reports as well. Thank you in advance for your time and expertise. I look forward to your insights and suggestions.Solved992Views0likes3CommentsEmbedding Paginated Report with Subreports in Power BI Desktop
Hello Power BI Community, I hope this message finds you all in good spirits. I am currently working on a project where I am attempting to embed a paginated report with subreports built on Report Builder into Power BI Desktop. While I've successfully embedded the main report, I am facing challenges with drill-through on the subreports. The subreports do not redirect within the embedded environment. I would greatly appreciate any guidance or assistance from the community on resolving this issue. If anyone has experience embedding paginated reports with subreports in Power BI Desktop, your insights would be invaluable. Additionally, if there are alternative approaches or best practices for achieving similar results, I am open to exploring those options as well. Thank you in advance for your time and expertise. I look forward to your insights and suggestions. [Note: Embedding in Power BI to acheive different groups/roles for RLS]Solved1.1KViews1like2CommentsPublish report From PBI Desktop to Report Server
Hi everyone I developed my report with PowerBi Desktop installed on my machine. I built several pages inside a pbix file. Now, it seems that this report won't be published on Service BUT in Power Bi Report Server. This information was not known at the beginning. So my question is: is it possible to publish a pbix file built with Power Bi Desktop to Power Bi Report Server even thoug the pbix file is not built with Power Bi Desktop for report Server or I have to start from scratch all my report? thank youSolved1KViews0likes2Comments