Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hansJLL
New Member

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

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?

1 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?Smiley Happy

 

Regards

View solution in original post

5 REPLIES 5

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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.

 

 2017-03-09 14_15_33-Snipping Tool.png

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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!

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?Smiley Happy

 

Regards

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors