Forum Discussion
Power BI Live Connection from SSAS
We are facing issues when accessing JDM cubes through Power BI. We are connecting through Analysis Services Live Connection .When we fetch the cubes there are duplicate dimension automatically appear in the list even through in JDM there is no such duplicates. Any Solutions .
Hi,Anonymous .I am glad to help you.
According to your description, you are using Power BI Desktop to connect to Analysis service multidimensional data (live connections connection mode) and you encountered loading multiple data with the same name and .value suffix.
In the multidimensional model (SQL Server Analysis Service), data with .
Value suffix usually represents the actual data portion of the measure, unlike the general tabular model where data is stored in the form of dimensions and measures, and .value represents the specific value of the measure.
Thus .value is a common naming convention in Power BI when working with multidimensional model data to identify the actual metric or attribute value.
You can try to check the data source where the AS multidimensional model is stored and see if there are any settings in there that are hiding these metrics so that you don't see the .value data on the data source side!
So I think what you are experiencing should be a normal phenomenon, because the difference in the definition of the multidimensional model and the report model is not the same when they are imported into power BI.
URL:Analysis Services multidimensional data in Power BI Desktop - Power BI | Microsoft Learn
Comparing Analysis Services tabular and multidimensional models | Microsoft Learn
DAX for multidimensional models in SQL Server Analysis Services | Microsoft LearnAnd about the live conncection connection mode data (whether it is a multidimensional model or a table model), Power BI generally only show the corresponding data source, in fact, a series of processing as well as data acquisition are taken from the data source stored in the model itself, Power BI generally do not have the power to directly edit these model data, only the power to use ( Because power BI in this case only do data display, no editing privileges)
So I think you can go to the data source to check the data source is there corresponding problems.I also suggest you to seek more advice on SQL Server Analysis service forum, where you can get more professional help about AS multidimensional models.
URL:
Analysis Services Forum on SQLServerCentral
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi,Anonymous .I am glad to help you.
According to your description, you are using Power BI Desktop to connect to Analysis service multidimensional data (live connections connection mode) and you encountered loading multiple data with the same name and .value suffix.
In the multidimensional model (SQL Server Analysis Service), data with .
Value suffix usually represents the actual data portion of the measure, unlike the general tabular model where data is stored in the form of dimensions and measures, and .value represents the specific value of the measure.
Thus .value is a common naming convention in Power BI when working with multidimensional model data to identify the actual metric or attribute value.
You can try to check the data source where the AS multidimensional model is stored and see if there are any settings in there that are hiding these metrics so that you don't see the .value data on the data source side!
So I think what you are experiencing should be a normal phenomenon, because the difference in the definition of the multidimensional model and the report model is not the same when they are imported into power BI.
URL:Analysis Services multidimensional data in Power BI Desktop - Power BI | Microsoft Learn
Comparing Analysis Services tabular and multidimensional models | Microsoft Learn
DAX for multidimensional models in SQL Server Analysis Services | Microsoft LearnAnd about the live conncection connection mode data (whether it is a multidimensional model or a table model), Power BI generally only show the corresponding data source, in fact, a series of processing as well as data acquisition are taken from the data source stored in the model itself, Power BI generally do not have the power to directly edit these model data, only the power to use ( Because power BI in this case only do data display, no editing privileges)
So I think you can go to the data source to check the data source is there corresponding problems.I also suggest you to seek more advice on SQL Server Analysis service forum, where you can get more professional help about AS multidimensional models.
URL:
Analysis Services Forum on SQLServerCentral
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.