Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
tschen01
New Member

Account Schedule Line Table

Hi,

I am trying to query using postman for the Account Schedule Line Table. Looking specifically for the totaling and Dimension 2 Totaling columns.


If I try this:

https://api.businesscentral.dynamics.com/v2.0/{tenantID}/Production/ODataV4/{CompanyID}/powerbifinan...

I am able to get something like this

 

 

"value": [
        {
            "@odata.etag": "W/\"JzQ0O2RaeGZDSmZ6aVNkZmFqcFNRMjNXNUU2dnFpMURwZWpMek13UHlidWloMmM9MTswMDsn\"",
            "No": 1,
            "Date": "2019-01-01",
            "Closed_Period": true,
            "Account_Schedule_Name": "_INC_ALL",
            "KPI_Code": "code",
            "KPI_Name": "NET INCOME (LOSS)",
            "Net_Change_Actual": 0,
            "Balance_at_Date_Actual": 0,
            "Net_Change_Budget": 0,
            "Balance_at_Date_Budget": 0,
            "Net_Change_Actual_Last_Year": 0,
            "Balance_at_Date_Actual_Last_Year": 0,
            "Net_Change_Budget_Last_Year": 0,
            "Balance_at_Date_Budget_Last_Year": 0,
            "Net_Change_Forecast": 0,
            "Balance_at_Date_Forecast": 0
        },

 

 

 

 

But When I export the Config File and get the Acc. Schedule Line table it has more columns then the powerbifinance query.

Account Schedule Lines ColumnsAccount Schedule Lines Columns

I have also tried using the webservice endpoint to look for endpoints that could get me this table(I have tried Account_Schedules and Acc_Schedule_Overview) which both have relvant information but not the columns im looking for.

 

 

How should I approach this? Or is it even possible to get that information?

Thanks!

 

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@tschen01 

Did you figure it out ? This URL shows me an error.

 

Regards
Paul

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors