Dashboard in Direct Query on SSAS Tabular : Conceptual Schema step very slow
Hello everyone, We have Power BI Report Sevrer, with direct query dashboards on SSAS Tabular. When we click on a dashboard, it takes about 30 seconds to display because of a step called "ConceptualSchema". (see screenshot). I understand that it loads the SSAS model metadata, but 30 seconds each time it opens is unacceptable. Do you have this problem? Did you solve it? Thank you in advance for your help, Have a nice day, Vivien
Power BI Report Builder Query 'explodes' after adding measure
Hi all, If have a report builder report that uses a query on a SSAS Tabular cube. All works fine, until I add a new measure. When I add this new measure all memory is used and the report crashes. The measure works in power bi like in this table : The measure (for example) #ArrivedLate is a count of all the rows having the the value 'Late' in a calculated column of the SSAS model. And the calculated column is a formule based on several time registrations. All I want to do is recreate the table using the same measures, like this : The column NumberOfTransports is a measure in the SSAS Tabular model as well, but this is a simple count formula. Same goes for the measure avgTimeOnTerminal, TotalLoadingTIme, TotalTimeOnTerminal which are all simple calculations. So why does my query explode and use all memory when I add the measure #ArrivedEarly ? Thanks in advance. Jacco
SSAS Tabular Model Process - Low Memory Error (Standard Edition)
This is the environment I work with: Microsoft SQL Server 2017 Standard Edition (64-bit) One database engine instance with 3 databases One Analysis Services instance with 4 databases (Tabular model, average size of each database 3.9 gb) Database engine and ssas are on same server. Server has 256gb ram; 80gb allocated to database engine, 60 gb allocated to etl tool. I read, if SQL Server is Standard Edition, it will assign a limited memory (15gb) to analysis service database. Also I can not create a new partition for one table. I wanted to create multiple partitions for one table and refresh/process only partition which has hot data. But I couldn't do that. So unfortunately, I have to full process for each tables. If there is an option to achieve this? Here are my steps to process: When I try to deploy ssas tabular model via Visual Studio, it throws "low memory" error. I have 10 tables in my tabular model, so I filtered table queries to "select top 10". After that I deployed the model successfully. After first step, I edited and removed "top 10" part from each tables partition in SQL Server Management Studio. I extracted full process script for each partitions, created a linked server between database and ssas instance. I created cursor to process partition of 10 tables. But I got an error "low memory". Here is an example of process a partition. DECLARE @MyScript NVARCHAR(MAX) = '{"refresh":{"type":"full","objects":[{"database":"Dwh_Reports","table":"Fact Sales","partition":"Par_Fact_Sales"}]}}' EXEC (@MyScript) AT SSAS To sum up, my questions; I have 4 databases on my ssas instance. That means, per instance uses 15gb memory and i have to allocate 60gb memory to ssas? My ssas instance configuration is default, I didn't change anything; Memory \ LowMemoryLimit -> Value : 60 Memory \ TotalMemoryLimit -> Value : 80 Memory \ VertiPaqMemoryLimit -> Value : 60 Memory \ VertiPaqPagingPolicy -> Value : 1 Do I have to change this configurations?SSAS Calculation Groups in Report Builder
I'm building reports in Power BI Report Builder using calculation groups (time intelligence) in a live connection to an SSAS Tabular model. Reporting Services is querying SSAS via an MDX query (since DAX has big issues with multi-value parameters). When the report is run, it doesn't seem to constrain the date values - the same calculations work properly in Power BI. I have max & min date measures in the calendar table - the report is displaying the min and max values of the selected date parameters, not the calculations for YTD, MTD, TTM, etc... Has anyone else experienced this?
Paginated Report with Tabular Model source and a parameter included - PARAMETER WONT WORK
Hi Created a paginated report (pointing SSAS Tabular Model format) in Visual Studio 2017 (for SQL Server 2008 / 2012 / 2014 version) and deployed to our PowerBI Report Server site. report is visible as paginated report and runs fine with data source set up correctly. 159 page report with page break by one of the groupings. Reproduced and included Parameter from the MDX source and parameter wont work in Visual Studio - it will render the report but not filter by the parameter I may select - still produced 159 pages. Deployed to PowerBI Report Server and report works, parameter accepted in manage report settings but again, when running the report, parameter will not work when I select an individual - still produced 159 pages. Please advise if me or whether a bug which Microsoft need to address? Thanks
PBI Report Server security to SSAS-T model
Hello I have this scenario: 1. SSAS-Tabular model in a server. 2. Power BI report created with Power BI Desktop (March 2018) with Connect Live to the tabular model. 3. A local Power BI Report Server. I would like the users of the report to use their credentials to visualize it through the Report Server (because I define roles in the cube). I go to Manage-> DataSource and I try this different options: If I select "Windows Authentication" and "As the user viewing the report", doesn't work: Data source AnalysisServices is not supported. If I select "Use the next credentials" and check "Log in using these credentials, but then try to impersonate the user viewing the report", doesn't work: The 'DOMAIN\user' value of the 'EffectiveUserName' XML for Analysis property is not valid. If I select "Use the next credentials" works fine. With the option 1, I can see this error on the visualization: "To connect as the user who is viewing the report, the organization must have Kerberos limited delegation configured." How should the datasource be configured for the user to pass their credentials so that the roles can be applied? Thanks
