Can't find data source lively connected to Tabular Model (SSAS).

[hansJLL]

Recently, I'm live connecting from Power BI desktop to Analysis Service tabular model. Once connected, I navigate to data source, it displayed cannot find data source for this file, however, I still could see the tool is lively connected on the right bottom status bar and still can create the report through the field list. I am pretty sure I could see the data source in previous version or before. But now, it lost the ability to change between dev and qa. What's the issue of this?

[Seth_C_Bauer]

@hansJLL What does Edit Queries -> Data Source Settings return? This should be your connection information that you can update...

[hansJLL]

Thanks for your fast response. Please see the screenshot and it should not behave like that. It can be always find as you clarified the way to find data source. However, all my reports now lost data connection but still can filter data and load data through the live connection.

 

[Seth_C_Bauer]

@hansJLL hmm. Are you logged in to the Desktop? In the upper right it should say your name.

[hansJLL]

Hi, I figured out, I thought it was in data source settings, actually, you are right, it was in edit queries and then I could edit the data source settings. But it is still strange that I could not find data source through file menu->options and settings -> data source settings. 

Anyway, it resolved my issue, thanks!

[v-ljerr-msft · Accepted solution]

Hi @hansJLL,

Great to hear the problem got resolved! Could you accept the helpful reply as solution to help others who may have similar issue easily find the answer and close this thread?

Regards