PowerQuery(MScript) in PowerBI using DAX

PowerQuery can take data sources (Excel tables, CSV files, database tables, webpages, etc.) Now, we can use it in PowerBI as well. So, iIn this workshop we will work upon:

• How to use Powerquery to know projection function in DAX.

• Understanding of lineage using powerquery with DAX.

• How to apply relationships(1-1,1-2-Many) using powerquery.

for sample data https://tinyurl.com/y8lwxjal

If you wish to install powerbi. please follow this link https://powerbi.microsoft.com/en-us/downloads/

it is only 110MB file.

In case you have a problem finding us or you will be late, please call us on 9163 4228

Note: From now on all the presentations will be in MSppt as well as PowerBI dashboards to get the better visualisations of data :)