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!!👍



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 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      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!!👍



      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Following your instructions, I was able to find that my "helper queries" needed to have the URL path updated to Sharepoint.

         

        Going to start looking into dynamic parameters to avoid this in the future, but thanks for your help!