Reporting integration with Power BI

[former_member820583]

I am integrating SAP Enable Now with Power BI to create reports. However, I noticed this particular power query is giving me the data source error.

Power BI template provided in info center: Workarea Analysis

Power Query:

Source = Table.FromColumns({Lines.FromBinary(Web.Contents(Origin, [RelativePath="wa/tools/group/GR_6A9B3045092EDDAD/.tree_path"]), null, null, 65001)}),

Error:

An error occurred in the ‘GetObjectTreePath’ query. DataSource.Error: Web.Contents failed to get contents from 'https://{instance}.cloud.sap/wa/tools/group/GR_6A9B3045092EDDAD/.tree_path' (404)

The group (GR_6A9B3045092EDDAD) is a static value provided in the power query. Hence, I am wondering where does it come from and why...Could anyone please advise?

[ShaneLipke]

Hi Choong Win,

That value is the unique ID of a specific Group (folder) object in the Workarea that the report was written against. If I were you, I would get the ID of the root group folder in your Workarea and try using that. If that doesn't give you the results you are after, raise a ticket and ask for help because the developer of that dashboard will be able to answer that question.

Regards
Shane