Forum Discussion

Jpalji's avatar
Jpalji
Frequent Visitor
6 years ago

Can we replace the existing Excel data source with other sources?

Hi,

 

Can we replace the existing Excel data source with other sources?

 

Thanks in advance.

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Jpalji 

    You could  refer to this thread.

    There are two ways:

    Home->Edit queries->Data source setting->change data source

    Home->Edit queries->Edit queries->Advanced editor, replace the connection string code.

     

    It is important that if the data model are different from excel and other data source, then the visual or measure/calculated column created already would break.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.