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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
arun_1047
Helper I
Helper I

Data source Tab not enabled While using SSAS Import Option

Hello,

Sceanrio:

  Under Prod Server, we do have many SSAS Cubes. I wanted to get each cubes Last Processing Date.

Following are the steps which i performed in the Power BI Desktop

1) Created SSAS Analysis Service connection (using Import Option).

2) Changed the Access type to Basic from Windows credential

3) Pulled the record from Meta data 

4) Created a report and published to the Report Server.

5) If i want to change the  credential from account to system account. When i looked and Datasource section it is completely

disabled in the power BI Oct GA version

 

Please let me know is there any other way  i can get the cube Last processing date directly without using (OpenQuery/OpenRowset in SQL)

Capture.PNG

 

Power BI desktop Version 2.514885.1423 64 bit (Oct ,2017)

Power BI reprot server : Oct 2017 GA latest version

 

0 REPLIES 0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.