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.
scs
Hi,
When I try to connect power query to some workbook I get the message below, any idea what can I do ?
Hi @Recoba88
It's a little bit hard to help you without further information (source (Excel?) , screenshot of table etc.).
Ok,
is it possible that the reason is the files saved in office 2007 and I try to open them in office 2016 - power query
?
Hi @Recoba88,
Do you connect to the Excel 2007 file from Power Query in Excel 2016? If so, which format do you save the Excel file as, .xlsx or .xlsb?
Besides, please directly open the file and check if you get restricted Access message. Based on my research, the error could occur due to access restrictions.
Thanks,
Lydia Zhang
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |