You Power BI Desktop consolidates lots of different sources in a single model and it would be very hard to get the same output as you get in Power BI Desktop model in Excel.For some reason you have just a Power BI Desktop file (PBIX) and you don’t have access to the data sources and you need to provide the data to someone who is not familiar with Power BI.The reason could be one of the following that someone wants to export data from Power BI Desktop model to other destinations like Excel, CSV, SQL Server etc. So why not using Excel at the first place to load data from the source? There might be lots of other questions about the reasons that someone wants to export data from Power BI Desktop model to Excel (or any other destinations). Power BI brings Power Query, Power Pivot, Power View and Power Map together in one piece of software. The first question lots of you might have is “How on earth someone wants to export data from a Power BI Desktop model to Excel OR CSV?”. Note: I’d like to make it clear that in this article we are NOT interested in exporting data from a visual in a report to CSV. One of the features that is asked a lot on Power BI community is how to export Power BI desktop data to Excel OR CSV. The method explained here is only applicable for Power BI Premium or Embedded capacities with XMLA endpoints connectivity. If you’re interested in exporting the data model from either Power BI Desktop or Power BI Service to CSV or SQL Server check this out. You can now export the data direct from Power BI Desktop using my tool, Power BI Exporter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |