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.
What is the reason that some connected Excel workbooks present as Excel books, and others as Web ? All of the sources are Excel books, but we noticed that books with .xlsx extensions exist as Excel, but .xlsm as Web connection. What is the reason behind of that?
Screen:
https://i.imgur.com/MzSDt5S.png
Solved! Go to Solution.
Hi @Anonymous
Normally when importing local file in Power BI Desktop, we'll use specific file-type connector to import that file. However, if the file (such as Excel workbook or CSV) is located on the web, we must use the Web connector to import the file. Power BI will judge the type of the file itself. If Power BI judge the content of link as an Excel workbook, it will connect to the data source like connecting to an local Excel. If Power BI judge the content of the link as an web page, it will connect to the data source like connecting to a web page. For Excel exists as Excel or Web connection, this should be affected by the version of the Excel file and Data display format in the link.
1 Connect to a xlsx file on OneDrive by Web connector
2 Connect to a xlsm file on OneDrive by Web connector
3 Connect to a CSV file on OneDrive by Web connector
4 Connect to a xlsx file on Google by Web connector
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @Anonymous
Normally when importing local file in Power BI Desktop, we'll use specific file-type connector to import that file. However, if the file (such as Excel workbook or CSV) is located on the web, we must use the Web connector to import the file. Power BI will judge the type of the file itself. If Power BI judge the content of link as an Excel workbook, it will connect to the data source like connecting to an local Excel. If Power BI judge the content of the link as an web page, it will connect to the data source like connecting to a web page. For Excel exists as Excel or Web connection, this should be affected by the version of the Excel file and Data display format in the link.
1 Connect to a xlsx file on OneDrive by Web connector
2 Connect to a xlsm file on OneDrive by Web connector
3 Connect to a CSV file on OneDrive by Web connector
4 Connect to a xlsx file on Google by Web connector
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Thank you for clarification.
I was wondering mostly about first two points you have mentioned, xlsx / xlsm. What is the difference for them for Power BI, that they have different types of connection? Both of them Excel books, and both are stored on OneDrive.
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.