cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yzahrkov
Frequent Visitor

Excel or Web connection in dataset linear view: why so?

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

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @yzahrkov 

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

v-cazheng-msft_0-1620032545218.png

 

2 Connect to a xlsm file on OneDrive by Web connector

v-cazheng-msft_1-1620032545221.png

 

3 Connect to a CSV file on OneDrive by Web connector

v-cazheng-msft_2-1620032545222.png

 

4 Connect to a xlsx file on Google by Web connector

v-cazheng-msft_3-1620032668217.png

 

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!

 

 

View solution in original post

2 REPLIES 2
v-cazheng-msft
Community Support
Community Support

Hi @yzahrkov 

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

v-cazheng-msft_0-1620032545218.png

 

2 Connect to a xlsm file on OneDrive by Web connector

v-cazheng-msft_1-1620032545221.png

 

3 Connect to a CSV file on OneDrive by Web connector

v-cazheng-msft_2-1620032545222.png

 

4 Connect to a xlsx file on Google by Web connector

v-cazheng-msft_3-1620032668217.png

 

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!

 

 

View solution in original post

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors