Forum

Hi Alicia, Great to hear you're enjoying the course! Thanks for sharing the link. You didn't say which tables you were planning on using from Qu...

Hi Anita, If you want a chart that includes AC1, AC2 and AC3, you simply select them in the PivotTable filter for the Channel Name. i.e. put the ch...

Hi Bax, Please see this tutorial on searching for text strings in Power Query. Hope that points you in the right direction. Mynda

Hi Alicia, Thanks for confirming it wasn't 5.04. I presume you meant 5.05 even though you wrote 5.04 again in your reply 😉 What I say in that ...

Hi Anita, Once you Close & Load the first time, the only place you can edit the load to settings is by right-clicking the query in the Queries ...

Hi Jennifer, Better to use a lookup (merge tables): Or you can use List Functions: Or if it's an approximate match: Mynda

Hi Alicia, I just listed to 5.04 and I don't mention avoiding using ODBC connections...are you sure it was this lesson? Mynda

Hi Heoun, Welcome to our forum! Power Query/Power BI require the table names to be unique. It will append numbers to any duplicate table names a...

I teach that method in my Power Pivot lessons because this is a standalone course (i.e. doesn't cover Power Query). However, the best/recommended way ...

Hi Ian, You should be fine to cut and paste or select the column and left click and drag holding the SHIFT key to insert the column in its new loca...

Hi Martin, Welcome to our forum! Ideally, you should be using Power Query to import your data to Power Pivot. I trust you won't have any issues ...

Hi Michael, You and each of the customers accessing the reports would need a Power BI Pro license (which is US$10/month), so that you can use the R...

Hi Sheralee, Welcome to our forum. I can't tell much from the screenshot, but it looks like the PivotTable may be already returning the results ...

Hi Michael, Welcome to our forum! Power BI is the tool designed for sharing specific data with different users as you describe above. The only a...

Hi Anita, Answers to your bullet points below: There are 6 channels (column B). 3 for AC load net and 3 for PV site net. The data needs to b...