Forum

2.09 From Web by Ex...
 
Notifications
Clear all

2.09 From Web by Example Issue

4 Posts
2 Users
0 Reactions
150 Views
(@rsprim)
Posts: 6
Active Member
Topic starter
 

Hello!  I just signed up and started with Power Query.  I'm on section 2.09 and seeing some weird behavior.  I downloaded PowerBI Desktop v2.123.742.0 64-bit (November 2023).  I'm using the URL in the video of https://worldcat.org/search?q=Eysenck&fq=&dblist=638&start=1&qt=previous_page and the Add Table Using Examples is coming up blank.  Any ideas what is going on here?  Thanks for the help!

 

PowerBI-Add-Table-Using-Examples-1.jpgPowerBI_Navigator-1.jpg

 
Posted : 24/11/2023 7:27 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Robert,

I think that site has changed its structure/layout, so Power Query isn't able to work with it as it did when I recorded the video. 

If you'd like a site to use for practice, try this page where there is a table of 4 phones listed at the top that you can get data from. 

Mynda

 
Posted : 25/11/2023 4:17 am
(@rsprim)
Posts: 6
Active Member
Topic starter
 

Hi Mynda,

That site worked better but I'm still having some issues which I believe are related to my lack of knowledge of PowerBI.  I was able to import the data from a generated table but I had some issues adjusting the dollar amounts in the fields.  I couldn't figure out how to edit them.  Can you update the video with an example that we can follow along with when you get a chance?

Robert

 
Posted : 25/11/2023 6:38 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Robert,

What exactly were you trying to do in terms of editing? Change amounts, change formatting, something else?

Mynda

 
Posted : 25/11/2023 7:28 pm
Share: