Forum Discussion

cisaemp's avatar
cisaemp
Regular Visitor
3 years ago

There was an error when processing the data in the dataset from SharePoint

Hello!   I have a Power Bi report getting data from SharePoint.  Everything works fine in Power Bi Desktop, but this weekend the automatic refresh from Power Bi Service has an error when processing...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 

You need to Open Power Query and check out the steps. But before you need to read message 9 and  14 .

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi 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