Forum Discussion
"Hidden Columns" in Source Data
Anonymous,
Do you use Data->From Other sources->From Analysis Services option in Excel to connect to your database and get the the data as shown in image2?
image1image2
If so, when connecting to SSAS database in Power BI Desktop, please choose "Connect live" mode. This way, you will get similar data structure as that in Excel. You can review image4 to get more details.
image3image4
However, if you use import mode in Power BI Desktop to connect to the database, the method is same as that you use "Data->New Query->From database->From SQL Server Analysis Services Database" option in Excel.
Regards,
LydiaAnonymous,
In connect live mode, it is not possible to connect to additional data source. We are only able to connect to a single SSAS database.
In order to get "stop light" icon in Power BI Desktop, you would need to create measures on SSAS side.
Regards,
Lydia
Anonymous,
Do you use Data->From Other sources->From Analysis Services option in Excel to connect to your database and get the the data as shown in image2?
image1image2
If so, when connecting to SSAS database in Power BI Desktop, please choose "Connect live" mode. This way, you will get similar data structure as that in Excel. You can review image4 to get more details.
image3image4
However, if you use import mode in Power BI Desktop to connect to the database, the method is same as that you use "Data->New Query->From database->From SQL Server Analysis Services Database" option in Excel.
Regards,
Lydia
Lydia: Thanks for the suggestion. My initial import was an import. I did try the live connection to see if it worked, but I am hoping to connect an additional data source. As you can see for my sales order field I did not get the same "stop light" icon that you have for your data. Any other suggestions you might have would be appreciated though.
Anonymous,
In connect live mode, it is not possible to connect to additional data source. We are only able to connect to a single SSAS database.
In order to get "stop light" icon in Power BI Desktop, you would need to create measures on SSAS side.
Regards,
LydiaAnonymous Thanks for the further info. I under the challenge of a single live connection but that's exactly what I'm trying to do in joining in more info. I may need to go back to my IT organization.