In SSAS Tabular with compatibility level 1200, you can import data either from table or by specifying query using second option shown in the following snap however same option is not present in SSAS Tabular with compatibility level 1400.
So what to do if you want to import data using a query instead of importing table or view in SSAS Tabular with compatibility level 1400. You can achieve this by using following steps.
1. Open the "Tabular Model Explorer" and right click on "Expressions" folder and click on "Edit Expressions" option.
4. Once you click on Enter button, you will be able to see data below formula bar. Right click on newly created expression. here in my case, I have renamed it to DimEmployee. And click on "Create New Table" option.
5. Once you click on "Create New Table" and navigate to "Tabular Model Explorer", you can see new table being created under "Tables" folder.
So what to do if you want to import data using a query instead of importing table or view in SSAS Tabular with compatibility level 1400. You can achieve this by using following steps.
1. Open the "Tabular Model Explorer" and right click on "Expressions" folder and click on "Edit Expressions" option.
2. When you click on "Edit Expressions" option, it will open "Power Query Editor" window. Navigate to "Query" -> "New Query" and then click on "Blank Query" option.
3. Under formula bar, type like the following syntax where DataSourceName is the name of your data source and mention query as per your requirement.
= Value.NativeQuery(#"DataSourceName", "SELECT * FROM Table")
5. Once you click on "Create New Table" and navigate to "Tabular Model Explorer", you can see new table being created under "Tables" folder.
ReplyDeleteEpson printers have put The bar of quality quite high for its own counterparts. It is every desired feature that an ideal printing machine must own. The Wonderful mix of features and performance have made it the most Perfect option from the personal level printing to precise printing for specialist reports through Epson printer support phone number.
Epson printer service is the title that millions of consumer rely on around the world. The house of Epson is Japan, but today it may be observed in every corner of the planet. No matter how much technology has gone, but there is not any perfect equipment was introduced yet. Likewise, Epson printer customer service number isn’t technically faultless, as some small and important errors pop-up unexpectedly. These unexpected defects not just hamper the workflow but also make a severe influence on the printing process. But don’t lose your heart, every lock has its own key. So, whenever Epson’s users experience an inconvenience, they can publicly speak to independent Epson Printer Support Phone Number
.
Nice & Informative Blog !
ReplyDeleteQuickBooks is an accounting software that has rapidly captured the global market,To get rid of QuickBooks problems, call us at our QuickBooks Customer Support Number 1-877-751-0742.
Hey! Good blog. I was facing an error in my QuickBooks software, so I called QuickBooks Error-6000,-832 (855)756-1077. I was tended to by an experienced and friendly technician who helped me to get rid of that annoying issue in the least possible time.
ReplyDeleteHey! Fabulous post. It is the best thing that I have read on the internet today. Moreover, if you need instant support for QuickBooks, visit at QuickBooks Error 15106 Our team at QuickBooks Error 15106 is always ready to help and support their clients.
ReplyDeleteNice and Creative Blog!! I really want to read more content of your blog, please keep posted regularly!!if you are facing any issue in QUICKBOOKS, please visit:
ReplyDeletequickbooks Customer Service
Borrow money here today at 3% interest rate. My company offers all kinds of financial services at 3% interest rate and our services are 100% guarantee and risk-free. to Apply, contact my company via email: sawda.finance@gmail.com
ReplyDeleteHey! Excellent work. Being a QuickBooks user, if you are struggling with any issue, then dial QuickBooks Customer Service. Our team at QuickBooks will provide you with the best technical solutions for QuickBooks problems.
ReplyDeleteHey! Nice Blog, I have been using QuickBooks for a long time. One day, I encountered QuickBooks Customer Service in my software, then I called QuickBooks Customer Support Number. They resolved my error in the least possible time.
ReplyDelete
ReplyDeleteHey! Lovely blog. Your blog contains all the details and information related to the topic. In case you are a QuickBooks user, here is good news for you. You may encounter any error like QuickBooks Error, visit at QuickBooks Support Phone Number for quick help.
This comment has been removed by the author.
ReplyDeleteThanks for sharing such useful information with us. I hope you will share some more info about your blog. Please keep sharing. We will also provide QuickBooks Customer Support Number for instant help.
ReplyDeleteGreat work! It is the best thing that I have read on the internet today. Moreover, If you encounter any error while working on QuickBooks for MAC Support , do contact this QuickBooks Support Phone Number (855)552-2543 number for quick assistance.
ReplyDeletehttps://aniruddhathengadi.blogspot.com/2019/07/ssas-tabular-compatibility-1400-use-sql.html?showComment=1640610906136#c3338959320014408545
ReplyDeleteNice and Creative Blog!! I really want to read more content of your blog, please keep posted regularly!!if you are facing any issue in QUICKBOOKS SUPPORT SERVICE SUPPORT. you can contact us at.+1 855-548-4814
ReplyDeleteVery good and quick service. I would like to thank the QuickBooks Support Phone Number +18556753194 team for their effective assistance. Our team at QuickBooks will provide you with the best technical solutions for.
ReplyDeleteAssuming that the issue continues, contact the QB online login help group. Then, at that point, return to the QB online login page
ReplyDeleteQuickBooks Desktop premier 2021
you can always call the customer service number to speak to an over-the-phone agent who will help you with the issue. The number for this service is Quickbooks Suppport Phone Number 8555644161.
ReplyDeleteThanks for sharing amazing blog. Yoga can makes the easy to control your mind ,to understand about your mind and to keep calm your mind. Yoga, Female fitness , yogainfo ,you reach us at
ReplyDeleteGreat Blog Thanks For Sharing With us if you have any problems regarding Quickbooks then you can call at
ReplyDeleteQuickbooks Support +18886942987