Forum Discussion
There was an error when processing the data in the dataset from SharePoint
Issue only after merging SAP HANA VIEW WITH SHARE POINT Schedule refresh is getting failed with out merge refresh is working fine in service. If we merge both refresh failing in service and working fine in desktop please suggest.
Community ChampionHi aj1973 ,
Firstly we are using Sharepoint Folder instead of Sharepoint Online Services and in point 9 &14 its shows steps for "Sharepoint Online Services"
Below is the screenshot of my folder path :
Then we chooses the file which is availble in the folder :
after transforming the data we are doing merge between SAP Hana data source and this WMS-REELID(file).
As soon as we do the merge between these two files sechdule refresh is not working however if i am not doing Merge and trying to refresh the data it's happening.
So not sure what is wrong with it . Request you to please help !
Regards,
Ashish
- aj1973
Anonymous
I would have to test it to tell you what's wrong. But in PQ try to refrence the sharepoint file and merge the refrenced file with Hana and see if it works.
aj1973 i did that. I referenced my query in PQ and applied the steps again and then mergerd my reference requery with SAP HANA Query but again same errot in PBI Service.
Not sure whats wrong with this.
Regards,
Ashish