Fetching data from Business Central Page 5159/ Table 5107

[Andre-SiS]

I am trying to fetch data from the page order archive (page 5159), to get data form the table 5107 (Sales Header Archive). However, when I fetch the data via PowerBI for Page 5159, I cannot see the column for Sales Quote No.  (Sales Quote No. (151, Code[20]).  

But at the same time, I cannot post Table 5107 as a web service directly in Business Central.

How can I solve this? 

[Anonymous · Accepted solution]

Hi @Andre-SiS ,
Based on your description, you are unable to see the Sales Quote No. column when using Power BI to get data from page 5159 of Business Central. You can try the following: First, make sure that page 5159 has the necessary permissions to display all columns, including Sales Quote No. Sometimes some columns may be hidden due to permission settings. Second, you can also create a new API page in Business Central that contains table 5107 (Sales Header Archive). Make sure to include the Sales Quote No. field in the API page. Publish the API page and use the OData connection in Power BI to fetch the data. Finally, in Power BI, edit the data using Power Query. If Sales Quote No. is available in another table, you can use the Merge Query function to merge the two tables. Make sure the data is converted to include all the required fields.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly