Forum Discussion

Patronez's avatar
Patronez
Regular Visitor
1 year ago

Help on Power BI and Power App integration

Hi everyone! I have a physical archive managed by an external vendor. I've created a Power BI database with 100% of the archive's contents and I'm comparing it weekly with a report the vendor sends ...
Need Help
Tutorial Requests
lbendlin's avatar
lbendlin
Super User
1 year ago

Example:

 

ClearCollect(colProjectsRaw, PowerBI.ExecuteDatasetQuery(
    "aaaaaaaa-bbbb-cccc-dddd-1234567890ab", /*Workspace GUID*/
    "bbbbbbbb-cccc-dddd-eeee-1234567890ab", /*Dataset GUID*/

    "EVALUATE
        SELECTCOLUMNS(VALUES('Projects'),
            'Projects'[ID],
            'Projects'[Description],
            'Projects'[Project_Manager])
        ORDER BY 'Projects'[ID] DESC"
    ).firstTableRows
);

ClearCollect(colProjects,
    ForAll(colProjectsRaw, {
        ID: Text(ThisRecord.Value.'Projects[ID]'),
        ProjectManager: Text(ThisRecord.Value.'Projects[Project_Manager]'),
        Description: Text(ThisRecord.Value.'Projects[Description]')
    })
);