Forum Discussion

emilne's avatar
emilne
Frequent Visitor
2 years ago

Gateway Mashup Data Error with Azure Function

I am working on a report that uses an Azure function as a data source. My query reads in two tables from a Sharepoint Excel file, converts them to JSON and then POSTs them to the Azure function via A...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi emilne ,

The error related to privacy levels indicates a conflict between the data sources' privacy settings. Since setting the privacy levels to "Private" resulted in a different error, it's important to ensure that both the SharePoint source and the Azure function have compatible privacy levels set. For more detailed guidance on configuring privacy levels.

As you mentioned receiving a error upon separating the SharePoint source and Azure function source into separate queries, this suggests an issue with combining data from these sources due to privacy level restrictions or the way the queries are structured. A potential workaround is to use two separate queries to load data from each source independently into Power BI and then merge or append the data within Power BI. For guidance on merging queries

Best Regards,

Xianda Tang

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