Connecting to SQL Server Analysis Services database

[Anonymous]

Hi,

I've built a data model (cube) in Visual Studio and I am now trying to connect to it through Power BI. Everything works out fine, but one table is missing in Power BI when connection is established. Does anyone have an advise on how to troubleshoot?

BR 

Lars

[artemus]

Maybe the table is hidden? Try right clicking the Fields and choosing "View Hidden"

[Anonymous]

Hi Artemus!

Thanks for your advise! You are absolutely right - the table was hidden. However, it is shown in the field section as light grey and I'm not able to expand it. I checked if the table was hidden in Analysis Services, but it is not. Do you have any additional clues?

Lars

[artemus · Accepted solution]

My guess would be that you showed the hidden table, but all the fields in the table are also hidden. You will also need to right click the table in the Fields view and choose Show Hidden on that as well.

Maybe analysis services doesn't do hiding in the same way? I would just import the model into Visual Studio and see if it is marked hidden there.