Solved: Connecting to SQL Server Analysis Services databas...

Anonymous · ‎01-15-2020

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 · ‎01-16-2020

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.

View solution in original post

artemus · ‎01-15-2020

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

Anonymous · ‎01-16-2020

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 · ‎01-16-2020

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.