Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team
I want to understand something important, when analysis report as excel. You download latest excel and comes with its software for all sql server with database connection including other datasource like Access. My question is do i need have drivers for this configuration be met? in order for me to read or view that report on the dashboaord, this is something want to achieve today as i am trying to figure this out by myself> i need some help to this process, kindly provide me enough support.
hi, @Anonymous
When you first use Analyze in Excel, you need to install updates to the Excel libraries. You’ll be prompted to download and run Excel updates (this initiates installation of the SQL_AS_OLEDDB.msi Windows installer package). This package installs Microsoft AS OLE DB Provider for SQL Server 2016 RC0 (Preview).
Please refer to this document:
https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel
Regards,
Lin
Ok this makes so far, now if i follow as prior to the documentation. WIll i able to download the file with actual data inside the excel sheet format. E.g My dashboard has report with streaming of data, now analyse it using excel as per above question. Will it indicate the same result i obtained from my dashboard.?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |