Forum Discussion

adavis9's avatar
adavis9
Frequent Visitor
4 years ago
Solved

How do I allow other users to update tables, currently only myself can refresh them

I have a workspace set up and have visuals etc.  There are other users that will need to update the tables going forward on the desktop version.   I have been on the web service and think that I hav...
Need Help
  • AUDISU's avatar
    AUDISU
    4 years ago

    adavis9 ,

    Please watch following video. It will give you an idea how to load data from share point folder.

    https://www.youtube.com/watch?v=XuLnSYjmsJo

    You do not need to re-build report again. You can change your existing data tables source from Folder to Sharepoint folder.

    Thank you.

     

  • AUDISU's avatar
    AUDISU
    4 years ago

    adavis9 ,

    Hi,

    You don't want to re do your visuals.

    Go to Advance editor option. It will show you all steps you have done for query.

    Click on PO Data (2) and click Advance editor copy and past first required codes to PO Data query.

    Do not do this changes in your original PBIX file. Creat a new copy and do this changes.

    Thank you.

AUDISU's avatar
AUDISU
Icon for Resolver III rankResolver III
4 years ago

adavis9 

Hi, You have loaded data using "Folder" option.
Load data from "SharePoint folder". Then it will be ok.

Thank you.

 

adavis9's avatar
adavis9
Frequent Visitor
4 years ago

Hi I have tried folder but it dosent bring up any excel sheets just folders, Ive tried sharepoint and it asks for a URL as below, not sure where i get that from. Also if i upload them again will i have to re-build or will it realise that its the same files uploaded 

 

  • AUDISU's avatar
    AUDISU
    Icon for Resolver III rankResolver III
    4 years ago

    adavis9 ,

    Please watch following video. It will give you an idea how to load data from share point folder.

    https://www.youtube.com/watch?v=XuLnSYjmsJo

    You do not need to re-build report again. You can change your existing data tables source from Folder to Sharepoint folder.

    Thank you.

     

    • adavis9's avatar
      adavis9
      Frequent Visitor
      4 years ago

      Thank you this has worked my colleagues can now access and update as required. Thank you for your help i really appreciate it.

       

    • adavis9's avatar
      adavis9
      Frequent Visitor
      4 years ago

      Thanks, I'll give that a go it looks like the solution is there. Will i have to re-do my visuals or is there a quick way to get BI to relise there's another table, for example my visuals link to PO Data but when i add the new source it creates PO Data (2)

      • AUDISU's avatar
        AUDISU
        Icon for Resolver III rankResolver III
        4 years ago

        adavis9 ,

        Hi,

        You don't want to re do your visuals.

        Go to Advance editor option. It will show you all steps you have done for query.

        Click on PO Data (2) and click Advance editor copy and past first required codes to PO Data query.

        Do not do this changes in your original PBIX file. Creat a new copy and do this changes.

        Thank you.