Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
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!
Solved! Go to Solution.
Hi @tschen01
You may refer this artical.
Best Regards,
Jay
Hi @tschen01
You may refer this artical.
Best Regards,
Jay
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.