After providing the parameters select one of the following buttons:
-
Load: To load the table into the internal Power BI Desktop data model.
-
Transform data: To make changes in the table before loading it into the internal Power BI Desktop data model. This option will launch Power Query Editor in a new window with a representative view of the table.
NOTE: If you see the Load button and the Transform Data button grayed, check the checkbox on the left-hand side.
After data loads to Power BI Desktop data model, you can create relationships between tables as well as create reports.
