Forum

Hi Aiyah, I'm not familiar with SQL, sorry. However, once the query loads, you might be able to get the database name from the Source step of the q...

No need to create a group. Simply put the channel name in the filters area and use the drop down on the PivotTable to check the boxes for the items yo...

Hi and welcome to our forum! You can automate this with Power Query. Alternatively, you can probably use some more formulas to make things a bit le...

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