export data
19 TopicsIssue when exporting data from a matrix
Hello all, I have the issue that when I create a measure to be shown at a certain level of the matrix, other than the very first level, I am able to export that data column and view it along with the others. The problem comes when I try to create a similar measure but that will be shown only at the very first level of the matrix, and not the rest, export data shows for that column as blank. So I've tried different approaches of creating the measure, but none of them seem to work if the measure appears at the very first level of the matrix, but it does work when exporting for other sublevels. Any facing this issue before, PFA the image to see better with sample data. Thank you in advance for your help.788Views0likes3CommentsExport paginated Report to tsv
How can I export a paginated report to tsv with a tab delimiter? In SSRS I could add an extension to the config file but that doesn't seem to work anymore. The option still shows but the file has a comma instead of a tab for it's delimiter.Solved888Views0likes2CommentsButton to Export Date
Today the end user can export data from a visual by clicking on the elipse and selecting Export data. I would love to be able to add a button that would do the same thing. Can you create a button to Export Data? Letting the user do it on the spot would be better than using a Power Automate flow. A flow that exports to Excel uses Apply to Each which is slow. I created a flow that exports the data to a CSV file in SharePoint but Power Automate doesn't offer an action to open a SharePoint file. In PowerBI I added a separate button to open the URL of the folder (Action->Type: Web URL). Opening the CSV file's URL causes it to be downloaded. I don't want to train end users to find the downloaded file so I open the parent folder instead.3.7KViews4likes1CommentExport Data: Data with current layoutIs
I need help getting the export option Data with current layout to be available for end users when I publish my report in the production server. Is it still available? I have changed the report settings but have not been successful. I am using a Table. I appreciate any information provided.522Views0likes1CommentIssue in export Data
Hello, I have a report in power BI server with a table-type visual object and I want to export to excel when exporting data only allows summary data to be exported, I get the following message: How can I unlock the other options to export data with current or Underlying data.1.2KViews0likes3CommentsExport Report to Excel with one employee per tab
Hello - I am building the paginated report in the screenshot below. I want to be able to export it to Excel where the text boxes and all three tables export to one tab in Excel. I also need to loop through several employees and create one tab per employee in the same Excel file. Looking for help on how to loop through a list of employees and create a tab for each. Thank you!659Views0likes1CommentCannot Export Data to Excel on a table visual published on a report on Power BI online server
I am trying to find the menu that pops up when you hover over a visual that lets you click on the 3 ellipses to then Export data. It is popping up on every visual except for my table visuals on a report I have published on the Power BI online server in one of my team's workspaces. It is strange because I have a different report published in this workspace where it allows me to export the data of a table visual, but this report doesn't even show me those 3 ellipses. I've checked my report settings and even tested with a user who has build permission and we still cannot see the 3 ellipses to export the data from a table visual.2.1KViews0likes5CommentsHow to make exported files stored in the website where the Power BI report is embedded in?
Hi, all, My Power BI report is embedded in a sharepoint webpage and my clients are colleagues who, by regulation, only work on and share the data internally. Currently it seems the exported forms of the report (PPT, PDF or excel files) are automatically downloaded to local PCs. Is there a way to make them stored on the sharepoint webpage where the Power BI report is embedded in? It would be of course possible for the users to download them there later (depending on the access right of the users that managed by the website). I have a data confidentiality reason for this need, but cannot find a solution. Thanks for your help in advance!Solved1.6KViews0likes8CommentsExporting a data set from Power Bi to be imported in to an object in Salesforce
Hi, We are constructing dashboards in Power BI (PBI), for information from our operational systems and as part of the requiremet we would like that information to flow from Power BI into Salesforce. We know that there is a connector from Salesforce up to Power BI to link easily data in Salesforce to create tables in PBI. We are wondering about the best way to have data flowing the other way, from PBI to SF in an automated way? Has anybody done this and if yes what are the steps to follow? Thanks in advance.Solved883Views0likes1CommentExport more than 150k rows from power bi report server to excel
Hwl The maximum number of rows that can be exported to .xlsx when in the Power BI service is 150,000 for Pro users but i want to export more than 150,000. Is there any alternate way to export more than 150,000 rows and how can i export it? Your response will be highly appreciated.3KViews0likes1Comment