Forum

Hi Krishna, You're running this from my query to NASA from this blog post? I don't know why you'd get that error. The Excel file still works...

Hi Danielle, Correct. Power Query shows you the data as it actually is, without leading zeroes. In Excel or DAX you can apply formatting to affect...

Hi Danielle, That's a formatting/display problem that you would do either directly in excel or in DAX, not in Power Query. Your attached Excel f...

You're welcome, glad to help. Phil

Hi Gary, It could also be that you're request is taking too long to complete. Web servers have a timeout on the length a request has to execute. ...

Hi Peter, If you haven't already, please read these posts on API's and Power Query Getting Started with API's in Power Query • My Online Trainin...

Hi Casey, Can you please supply a file we can work on so we don't have to try reproducing the data. Regards Phil

Hi Justin, No images attached I'm afraid. You need to click Start Upload to load the images. Read This First | Forum Rules and Guides | Excel...

Hi John, Yes, you don't even need to check if there are more than 4 columns, just select the columns you want and then right click on a selected co...

Hi Craig, Looking at the official documentation it looks like first keeps the first row (although this isn't explicitly said), removing duplicates ...

Hi David, If you mean can you convert columns to different data types in PQ, then yes, very easily. Likewise, joining columns together is simp...

Hi David, Use Power Query. The data looks like it's already been imported or copy/pasted - all numbers are text? If you use PQ to bring this data...

Hi, Have you read and tried the code from these posts You haven't said how you want the results to look so I've produced a table with the st...