Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: tabular

Unable to validate source query in Tabular Editor

January 21, 2021January 21, 2021 Koen Verbeeck Leave a comment

When you have a very large fact table in Analysis Services Tabular, you most likely have it partitioned. Suppose you are making some changes to the underlying source of the table and you hit “refresh table metadata” to add some new columns for example. What happens behind the scenes is that Tabular Editor will run […]

Read More

Change SSAS Tabular Data Source using TOM

May 8, 2018September 10, 2020 Koen Verbeeck 1 Comment

We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server using Visual Studio. Whoops, you forgot to change the server name in the data sources, so now your Tabular model in production is trying to read from the test database. Either it crashes – depending […]

Read More

Error Processing Tabular – Method Not Found

September 15, 2017September 15, 2017 Koen Verbeeck Leave a comment

Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012, I was greeted with the following error while processing a Tabular model: Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: Method not […]

Read More

Not An Administrator For Analysis Services Tabular

February 28, 2017February 28, 2017 Koen Verbeeck 2 Comments

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the nice error message saying I […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress