Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lastnn30
Post Patron
Post Patron

Why Excel Power Query is different from PBI Power Query

Hi 

I am reading this article

https://docs.microsoft.com/en-us/power-query/connectors/web/web-by-example

 

and trying to connect to this website 

https://www.microsoft.com/store/top-paid/games/xbox?category=classics 

 

usign Excel Power Query

 

But I can not find any table but when I used PBI power query, I see the list of all tables, please see screenshots. Why I do not see tables when I use Excel Power Query? Thank you very much.

SNAG-0756.jpg

++++++++++++++++

SNAG-0757.jpg

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @lastnn30 .

 

The Power Query has different developments in Power BI and in Excel, also in different versions of Excel you have a different development, so there is no direct match between the two, altough they are the "same" program.

 

Depending on the version you are on Excel or Power BI you have different options and connectors.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @lastnn30 .

 

The Power Query has different developments in Power BI and in Excel, also in different versions of Excel you have a different development, so there is no direct match between the two, altough they are the "same" program.

 

Depending on the version you are on Excel or Power BI you have different options and connectors.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.