Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data Source Settings

Hey All,   Trying to change my Data Source Setting in BI from a SharePoint connection to a local file. This is proving difficult as I do not see the option to add additional sources or edit the exi...
Need Help
  • ilton's avatar
    ilton
    4 years ago

    Hi Anonymous 

    You can do pretty much anything with your data in the transformation part

    1. Open tranformation editor

    2. Add the local file as a new source

    3. open the advanced editor

     

    4. Replace the source from the sharepoint query with the source from the local file query

    you may need to adjust a few things manually afterwards.

     

     

    Is this helps consider marking it as a solution

    If you need any help let me know

ilton's avatar
ilton
Icon for Helper I rankHelper I
4 years ago

Hi Anonymous 

You can do pretty much anything with your data in the transformation part

1. Open tranformation editor

2. Add the local file as a new source

3. open the advanced editor

 

4. Replace the source from the sharepoint query with the source from the local file query

you may need to adjust a few things manually afterwards.

 

 

Is this helps consider marking it as a solution

If you need any help let me know