Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Change data source

Morning, I have an issue about data source changing.   I have change data source from local to sharepoint via advance editor and it work properly but in data source parameter, the other local sour...
Need Help
mohammedadnant's avatar
mohammedadnant
Impactful Individual
4 years ago

Hi Anonymous 

 

Make sure you are using the web link of the SharePoint,

after replacing the data source --> close and apply in Power query --> check it load and try refreshing manually in Power BI Desktop.

if all ok then publish into Power B service.

 

it will work.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mohammedadnant ,

    As you can see below the data source is web link (from sharepoint)

    I don't know if it's the same like web

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      My main issue is to others people refresh or update the report.

      Is it possible without premium licence ?

      I have design a dashboard from local folder and after change folder to sharepoint to permit my collegues to update report.

      When I use, it work properly but when my collegues refresh, it say that it can access to my local file that i already move to sharepoint.

       

      • mohammedadnant's avatar
        mohammedadnant
        Impactful Individual
        4 years ago

        Anonymous 

         

        I believe your colleagues also have access to the same SharePoint folder.

        as per your message "It can't access the local file" means still some table(s) are connected to your local drive.