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 someone else the PBIX file so that after the report was compelte, I would give them access so they can do their own updates/refreshes.

 

It was originally built with a couple of Excel files on my C: drive. I moved those files to Sharepoint and re-mapped my queries to pull from the organization's Sharepoint site.

 

When attempting to refresh the dataset in the O365 Power BI refresh in my workspace, I get the following error. It's my first time attempting to update something from here. The folders should all be pointing at Sharepoint, so I'm not sure why it wouldn't be able to update.

 

I deleted the dataset and the report and republished, but it still gives me this error. Any insight?

 

 

 

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



7 Replies

  • 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  you dont need gateway configuration for sharepoint or onedrive since the data is online but yes you have to update the source details in power bi service under the dataset click on setting -->enter the datasource credentials thats it you are done...