On Microsoft AppSource

 Step 1:

The Dollar Grid template app can load user data from Dataflows in Power BI service.

Step 2:

Provide the workspace id and dataflow id. There are 3 tables that are required in the Dataflow. The schema for these three tables should be defined as explained in the following steps. For users without subscription, data should not include dates beyond 2025. Only subscribed users can load data beyond 2025. For support, please contact us at sales@bideploy.com.

Step 3:  

Financial Outlook

a. Order Number (Type: Text, Nullable: False)

b. Year (Type: Text, Nullable: False)

c. Cost Type (Type: Text, Nullable: False)

d. Jan-Dec 12 Columns (Type: Decimal Number, Nullable: True) 

Step 4: 

Financial Actuals

a. Order Number (Type: Text, Nullable: False)

b. Cost Type (Type: Text, Nullable: False)

c. Actuals (Type: Decimal Number, Nullable: False)

d. Fiscal Period (Type: Date (MM/DD/YYYY), Nullable: False)

e. Vendor Description (Type: Text, Nullable: True)

f. Cost Center (Type: Text, Nullable: True)

Step 5: 

IO List

a. Cost Category (Type: Text, Nullable: True)

b. Order Number (Type: Text, Nullable: False)

c. Order Description (Type: Text, Nullable: False)

d. Project ID (Type: Text, Nullable: False)

e. Project Description (Type: Text, Nullable: False)

f. Department (Type: Text, Nullable: False)

g. Region (Type: Text, Nullable: True)

Step 6:

Dataflow Authentication

For dataflow connectivity, please set authentication method to OAuth2 and Privacy Level to Organizational.