sql-serverssaspowerbi
PowerBI Desktop Cant Connect to Multidimensional Cube
I am trying to connect to Multidimensional Cube but it shows me error as above.
The SQL Server version is 2016 so thats not an issue. The SQL Browser service is running on the SQL Server host machine.
I can connect to the cubes using Excel so no question of firewall as well.
I will be glad if any one can help me with what could be the cause of this happening?
Also, i can connect to the Tabular Cube with the same PowerBI desktop just not the multidimensional one.
Solution
If I explicitly add the name of the database it works.
- Summation of a column using certain conditions
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?
- Is there any way to get lcid of current session in a function with schemabinding option?
- How to find databases which accessible to me in Sql server?
- Default encoding in SQL Server Management Studio
- Database stuck in "Restoring" state
- Unable to open BCP host data-file
- How to join parent object with nested array using OpenJson SQL
- Efficient paging with Repeater, SQL Server and custom Pager
- Queries using LIKE wildcards in sql server
- Conditional aggregation in SQL: display condition-dependent count in percentage?
- What would be the ideal way to do paging using a Infragistics WebDataGrid and SQL Server 2008
- output sql data to html with hyperlink
- Update all column names to be lowercase
- Connect python-polars to SQL server (no support currently)
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Query to get only numbers from a string