Forum Discussion

kimberlyazul's avatar
kimberlyazul
Regular Visitor
2 years ago

How to change my data source settings

Hello,

 

All of our reports are connected to SharePoint but now it's saying that I need a direct query connection 

I'm trying to change it back to SharePoint but as I change the data source setting this is what I'm getting

it should be something like this right?

how can I have that option again?

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    kimberlyazul , seem like you are connecting to dataset and it is live connection.

     

    under modeling, you have the option to change it to a direct query- "Make changes to this model"

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi kimberlyazul 

     

    I would like to apologize for the belated reply.

     

    After my testing, when you use LiveConnection connection mode, clicking on the button shown below brings up this prompt.

     

     

    I need a little more information to better help you if your problem is not solved, are you connecting the excel file on sharepoint?

     

    Best Regards,
    Community Support Team _Yuliax