Forum Discussion
Live Connection Vs. Direct Query for Datasets
What if the enduser uses direct query and combines the dataset with excel file which is in own onedrive?
I just want to avoid that enduser makes some mistakes in excel file which leads to crashes over night. Normally the dataset is used for a different report.
Pikachu-Power own OneDrive or shared with others is no problem. To my knowledge false data in the excel file won't crash whole report, just the visuals where for example the data from the excel are conflicting. You can tell the enduser whenever he makes changes to first make a backup copy and put it in another folder. if everything is okay it can be deleted. if not just overwrite the changed excel with the original one.
Or you can set up the excel more thoroughly, that you cannot make mistakes so easily. Like restricting what others can do with the excel. Only input of data columns, but not allowed to change anything else.
Hello and thanks for the ideas!
Is it possible to create for an existing workspace a microsoft teams channel and upload the excel file there? I think in teams channel under files both sides should have access to the file and it should be possible to load that in power bi.
I just saw the other way: when creating a teams channel a workspace is created. but i am looking for the other direction.