Export paginated report to excel with hyperlink and large amount of records
Hello everyone since the last (second release) update of power bi report server (may 2024), and after the issue with image solved (see https://community.fabric.microsoft.com/t5/Report-Server/Export-paginated-report-to-excel-with-image/m-p/3996645) we are facing another anoying issue. after exporting excel (with a large amount of record or excel size) we have another kind of error: the same report with a parameter that returns less records is correctly exported, and hyperlink are working. but with a parameter which returns a lot of records (about 40 k), we got the above message report is composed of a simple tablix, with some cells containing hyperlink in browser view, all works fine, and hyperlink are working. but after exporting to excel, it "crash" Any suggestions on how to get around this. regards,
Adding an overlay with a hyperlink to a line chart
I work on a data engineering team, and we have a PowerBI report that includes a line chart showing how long it takes for data to be processed. Spikes in this graph are typically related to an incident (configured in our incident management platform) that captures outages and disruptions to our service. I would like to display those incidents over this line chart (shown as red dots on the graph below). Each dot would represent an incident or group of incidents that fired at a particular time stamp. When I hover over or click on a red dot, I would like to see a tooltip or dialogue panel with more information about the incident(s) including incident number and a hyperlink to the particular incident on our incident management platform. Assuming the underlying data model is working and we are able to correlate incidents pulled from our incident management platform with the data from the line chart, what kind of visuals could I use to create these dynamic overlaid lables with hyperlinks? If there are no existing visuals that would allow this, has anyone tried any plug-ins or custom solutions that they could share? I would appreciate any help 🙂 cc: jayendransAdd conditional formatting or action customization for column headers in matrix and table visuals
I would like to suggest adding the option to conditional format column headers in matrix and table visuals as hyperlinks to enable quickly navigating to a web URL or a page within the report. For example, I have a report page that acts as a heat map with various columns show the health of each client (rows) in each of the various categories (columns). Subsequent pages in the report provide more detailed metrics and information for each of the corresponding columns on the heat map. I want to make it so the user can click the heat map column header and be redirected to the corresponding details page in the report. This is one of many instances where being able to conditional format a column header with an action or hyperlink would be helpful. For the above example, I do have a workaround in place, using "invivisible" action buttons, however these do not move with the headers in the event we need to scroll to the left or right in the matrix or table visual so I am limited to only showing the number of columns that can fit in the view without scrolling left to right.Power BI Visual hyperlink with parameters to display content in another visual
I'm wondering if it's possible to have a value in a table visual by a hyperlink with dynamic parameters that will populate another table visual when clicked? For example, table 1 has colums of "item desc", "date", "qty sold", "qty returned" with rows of "pink bikes", "2022-08", "5", "3"; "pink bikes", "2022-07", "8", "1"; "blue bikes", "2022-08", "18", "2". When the second row , column "qty sold" of "pink bikes" is clicked, table 2 visual would display the customers who bought pink bikes in July of 2022. But, if they click second row, column "qty returned", table 2 visual would display the customers who returned pink bikes in July of 2022. The first table is rolled up within the underlying sql, so I'd need to pull from a separate underlying data table with the information. Any ideas on how to do this? I'm happy to get into a video that's already available.
Hyperlink multiple slicers to a link
Dear Team, I have a test link https://powerbi.com/reports/powerbi/Production/testData_abcd and a slicer called "Region" with data: DE, IN, US,... Requirement: if users select a Region option then that value will be added as a tail in the link above. I already found a way with IF formulas: a) RegionSelected = IF(ISFILTERED(Sheet1[Region]),SELECTEDVALUE(Sheet1[Region]),"Select all") b) Formula1= IF([RegionSelected]="Select all","https://powerbi.com/reports/powerbi/Production/testData_abcd","https://powerbi.com/reports/powerbi/Production/testData_abcd?filter=Sheet1/Region eq '"&[RegionSelected]&"'") it meets the request, BUT if we have multiple slicers then I have to create another IF for each slicer and combine all of them in the DAX. It look too lengthy and unprofessional... For example: I have one more slicer called "Component". Another IF have been created as following: c) ComponentSelected = IF(ISFILTERED(Sheet1[Component]),SELECTEDVALUE(Sheet1[Component]),"Select all") d) Formula2 = IF([Formula1]="https://powerbi.com/reports/powerbi/Production/testData_abcd", IF([ComponentSelected]="Select all", [Formula1],[Formula1]&" and Sheet1/Component eq '"&[ComponentSelected]&"'") Question: Do we have another way to sync slicer with a link? Or another concise formula that can solve this problem? Could you please check and support? Thank you.Can't add hyperlink to text field for workbook published to server
I have a text field that I want to make a hyperlink using a URL from another field. Seems to work fine in a local desktop workbook but Power BI won't let me select a field to use as a hyperlink in a report published to the Power BI Server. Following these directions, https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables#format-link-text-as-a-hyperlink we've made sure that Data is in a Table we are using a version later that Feb 2020 (Sept 2021 to be exact) the URL column is "Uncategorized" in Data Catagory. But still nothing. Is this another one of those things that can't be done with Direct Query or a report publised to the server or something? Doesn't seem like it should be. I get to where you add the Web URL and is just won't let me select the field with the URL in it.
Hyperlink in Power-BI to local filesystem
When I want a hyperlink tot al localfile I can use file: //blabla.xls in stead of https ://www.blabla . I want to do soemthing similar in a text box. in Power BI. So only people with access to our local netwerkdrive may open this link. It seems not a standard thing, or do I miss something relevant? thanks for your reply.
