Forum

Oops! Good catch, Peter. Thanks for letting me know.

Hi Peter, That's odd. Make sure you're logged into Excel. If that doesn't help. Try the feedback button on the Help tab and send a report to Micros...

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

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. I...

Hi An, This is a setting change that you or your IT admin have to do. You can see if you have access to make the change by clicking on the cog icon...

Apologies, Bax. I haven't been clear. In Power BI you can copy and paste your data into a table. Doing this creates JSON code for your dataset in t...

Hi Ann, This week they renamed Datasets to Semantic Models! Just to keep everyone on their toes. So you want +New > Semantic Model. Mynda

Hi Bax, Just copy the query from the Advanced Editor in Power BI and paste it into a new query via the Advanced Editor in Excel. Mynda

Hi Steven, The error says that Microsoft 'changed or removed it on our side' meaning that they stopped supporting this data and there is no fix as ...

Hi Bax, You could convert the data to a static data table as explained here. If you have a lot of data, then you might like to use Power BI to past...

Hi Ayal, I edited the query and changed the data type for column E to whole number (as Velouria said, it's currently formatted to 123ABC which is d...

Hi Wendy, I cover Formula Firewall Errors in lesson 7.05. See if that helps. If not, please come back and let us know. Mynda

Bummer. I'd ask in the MS forum. You never know what other ideas that might come of it.

Hi Pieter, Thanks for creating the sample PDF. Power Query can't see the field data, so I think this is a non-starter for Power Query, unfortunatel...

Hi Pieter, I'm not sure what you mean by field name or field data, but Power Query can load any data from a PDF that's in a Table. Are you able...