analysis services

18 Topics

Cannot load model
Hi, When I open my .pbix file in Power BI Desktop app, I immediately get this message: Interestingly, the associated PowerBI report in the workspace seems to be refreshing from the model (and linked datasources) regularly. I need to make changes to the model however, and I can't do so in PowerBI Desktop, because of the 'Cannot load model' window. None of the visualisations appear in the Desktop app when i close the error message. I have found this page that refers to 'Analysis Services' also, but I don't know whether this is the right place to go to to try and rectify and overcome the issue. Any help would be much appreciated.
Solved
Anonymous
2 years ago Place Report Server
1.3KViews
0likes
1Comment
Power BI Report Builder v15.7.x compatibility with SSAS 2022
Hi all! Does anyone know if Power BI Report Builder v15.7.x is compatible with SSAS 2022? Thanks, Matteo
Solved
matteolocci
2 years ago Place Report Server
814Views
0likes
1Comment
How to do Row Level Security in PBI Report Server using live connection from SSAS cube
The data in SSAS cube. The cube has 1 flat table. No dimensions. All the relevant data is in this table. The reports are housed in the Power BI Report Server The table has a column called "ClientName" which lists the clients. The ClientName column has values like APPLE, GOOGLE, REDDIT etc. There are a about 8 clients like these. The goal of RLS is that we have a common report to be viewed by all users at all the clients' companies but the people at APPLE should only see data for the rows that have ClientName as Apple, and so on. We created 8 Active Directory groups for the 8 clients. And users from the client companies were added appropriately to them. For the actual RLS these are the steps I have followed. 1. Created Roles on the SSAS cube using SQL Server Management Studio. 2. Assigned only 'Read' permissions to the role 3. In the members tab, added the appropriate AD group to the role. 4. In the Filters tab, assigned the filter using DAX. For example for the Apple role, the expression was ='TABLENAME'[ClientName]="APPLE" A sample report was created with the ClientName column in a matrix visual. This report was uploaded to the Power BI report Server. In internal testing, this worked perfectly. We created a test cube that was identical to the production cube. Added a couple people from our own company to each of these AD groups. We assigned these AD groups to roles in the test cube. They were able to see only the ClientName assigned to them. We then tried testing with actual client users. Created a test report with a single visual as above with the report connected to the actual production cube. But they were able to see all the values in the column. I then tried to repicate the initial test by asking the initial internal users to test the first sample report. (Connected to test cube). But they were able to see all values in the column as well. Whenever I do "Analyse in Excel" in Visual Studio, I get the intended results in all the tests. (RLS is applied) Both on the test cube and the production cube I'm not sure what I'm doing wrong. Some more information: In Manage options for the report, Data Sources > Credentials > Authentication Type is Windows Authentication. And the option "use the following credentials" is selected. A username and password has to be entered in the field there. This was provided by the admin team. I'm not sure what the use of this is but thought I should mention. In Manage options for the report, Data Sources > Connection type is Analysis Services. The Connection String is appropriately edited as below Data Source=SERVERNAME;InitialCAtalog=CUBENAME;Provider=MSOLAP.8;IntegratedSecurity=SSPI;Impersonation Level=Impersonate; As far as I know, none of the users have been added to any of the administrators/developers AD groups. I'm not sure what I'm doing wrong. Please advise. Thanks
Solved
rincewind
3 years ago Place Report Server
3.6KViews
0likes
7Comments
How to get M query from dataflows. Power BI Server Analysis Services DMV request
The target is to get all M codes from Power BI Service. dataflows take a big part in the Power BI data structure. I tried codes that work for datasets, but they apparently do not work for dataflow: SELECT * FROM $SYSTEM.TMSCHEMA_PARTITIONS and SELECT * FROM $SYSTEM.TMSCHEMA_EXPRESSIONS In The Power BI Workspace opened with Analysis services there is an entity named "Dataflows" with all the dataflow inside. I try running the same codes for this entity as for datasets, but the results are weird. Some codes show reference to a table itself, and 90% of tables are missing. Is there a way to get M Query for all tables inside dataflow (loaded and not loaded) using DMV queries? d_gosbell , lbendlin could you help with this issue?
Solved
olegkazanskyi
4 years ago Place Report Server
2.4KViews
0likes
1Comment
DMV request to Power BI Server Analysis Services for hidden tables in PowerQuery
I try to get the list of tables with M codes from PowerBI online Analysis Service. I managed to get the required data with the request: SELECT * FROM $SYSTEM.TMSCHEMA_PARTITIONS But it doesn't show any tables that were selected not to "Load" in PowerQuery. The purpose of this task is to get all data connections from a dataset and hidden tables are essential. Does anyone know how to get the hidden tables' codes?
Solved
olegkazanskyi
4 years ago Place Report Server
5.6KViews
0likes
8Comments
SSAS Multidimensional & Tabular on Same Server
Hello, We are planning a migration of our SSRS server to an on-premise Power BI Report Server with the longer term plan to migrate everything to Azure & Power BI Service. There is guidance out there to not install SSAS Multidimensional & Tabular on the same server for performance reasons as they allocate and use the hardware differently, etc. My question is: What about for lighter workloads? We have a low user count. Over the past 2 years our SSRS server has served: 40 unique users per month at peak. On average 7 users per day with a peak of 21 on one of those days. Our data volume is quite low: Multidimensional cubes = 2GB. Tabular Model = 500 MB. Most of the rest of the reporting is via T-SQL procedures. If this is seen as a lighter workload scenario, could it be appropriate to install two instances of SSAS, one in each mode to buy time to then plan to move to the cloud? Or do you think it would make all performance horrendously slow, including any SSIS jobs? Thank you for any insights you may have. Brad
Solved
blynchdata
5 years ago Place Report Server
2.9KViews
0likes
2Comments
Prompt in a Power BI
Hi there, can I set in a power bi report a prompt in order to set a date ? I want to use it in order to define the limit date to my calculations (ytd, mtd, etc). It is possible at run time ask this to the user ? Thanks in advance
Solved
Anonymous
6 years ago Place Report Server
5.6KViews
0likes
1Comment
Multiple Connections Dax Query
Hi all, I have a premium workspace with various pubblications of the same app (same tables, model, but different dataset). If I connect with SQL Server Management Studio I can see all dataset correctly. There is a way to execute a query in all dataset? for example, i need to know how many rows has a table in each dataset. Thank's
Anonymous
6 years ago Place Report Server
1.5KViews
0likes
3Comments
Problems connecting to Analysis Services with Chrome
So my PowerBI RS install is on a separate server from my analysis services database server. Reports cannot be viewed due to not connecting to Analysis Services Ok, forgot SPNs, forgot to edit the report server config to put Negotiate at the top I setup SPNs, configure RS, restart RS and verify that reports I wrote in PowerBI RS Desktop can be viewed in IE. I then go to Chrome. Chrome still can't connect. It will connect to the server and let me browse around, but I can't run the reports.
mtassin
6 years ago Place Report Server
947Views
0likes
1Comment
Disable Analyse in Excel for datasets
Hello I want to turn off the "Analyse in Excel" feature for my datasets, as implementing RLS is not possible at the moment and i don't want my final users to see more than I show in the report. I manage to disable it in the report disabling the compilation access of the dataset and this greyed out the Analyse in Excel option, but I found another way of accesing. If I share the whole application, I have to share the dataset too. The user can enter My Workspace and the dataset will appear there. If he clicks the three dots, the following menu will appear and it will give access to the whole database. Is there a way to disable this? I already asked the administrator to disable the option in tenant settings to no avail. My source is Analysis Services Thank you in advance
Anonymous
7 years ago Place Report Server
4.6KViews
1like
1Comment