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

Hi cisaemp 

Open Power Query in the desktop and check out the Query folding steps. Sure you will identify the problem. Besides check out what has changed in Sharepoint.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

  • 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

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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.