Forum

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

Hi David, The icon configuration you're seeing is not because of your screen size. The first down arrow beside the Quick Access Toolbar icons revea...

Hi Kenneth, I would think so, but it's a bit difficult to follow what your formula is doing without an example file because on the face of it, MMUL...

Just confirming it's this (open the link to the image below rather than viewing this embedded image as it's distorted for some reason): If so, ...

Hi David, Do you mean the box with the file name and the down arrow? If so, this is available with Microsoft 365 accounts. What version of Excel do...

Hi Chris, Why don't you try using a PivotTable to get the count? Insert a PivotTable with column G in the row labels and the values area, with the ...

interesting, Cedric! Thanks for sharing.