Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Power BI desktop Version 2.514885.1423 64 bit (Oct ,2017)
Power BI reprot server : Oct 2017 GA latest version