Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Refresh Failed Due to Gateway Configuration - But All Source Files are on Sharepoint

I posted this to the Desktop forum but feel like it's more relevant here....   I created a Power BI report on desktop and have it published online. The report was built with the goal of giving some...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 
    Clear Cache-->File-->Option & Settings-->Options-->Global-->Dataload

    To delete the old datasource Transform-->datasource setting-->clear permission on all the old data source

    Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


    Appreciate your Kudos, Press the thumbs up button!!👍



moomarine's avatar
moomarine
Helper II
5 years ago

Hi if your organisation Sharepoint is on-premise you need to get it setup in the gateway but if its sharepoint online then as the last poster said you can setup credentials in the online service. But the fact its telling you to setup a gateway makes me think its on-premise.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    So I'm inclined to believe our sharepoint is on-premise, but don't have any validation of that. Just knowing our company, it's more likely than not.

     

    I went ahead with a personal gateway setup, just to poke around. What is puzzling, when I ventured to Data Source credentials, it's sitll showing my path to my C: drive. Even though, as I said, I re-mapped everything to be on Sharepoint.

     

    Why would this not change when I publish the updated report with the re-mapped sources?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous  did you delete the old source from data source settings and cleared cache?? if not kindly do that .


      I hope you have changed the new data source to all the files from Power query ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Anonymous sounds like that's headed in the right direction, although admittedly I'm unfamiliar with that step 'delete the old source from data source settings and cleared cache'. Can you elaborate on where this is completed?

         

        I did change the PQ data sources to be the sharepoint folders. That's what I have touched on in my post, but my lack of understanding of the service side of things has probably caused some confusion 🙂