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.
I received this error from Power Bi "Get Data" procedure:
Firstly, refreshing against a .xls file is not supported. As stated in this article, Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type. You would need to change Excel file from .xls to .xlsx.
Secondly, how do you connect to the database in Excel? When you connect to the database in Excel, please make sure that you load data into data model, and after you import data from Excel to Power BI Service, add the database source within gateway, then check if you can refresh the dataset successfully. For more details, please review this article.
Regards,
Lydia
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |