Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Maybe the table is hidden? Try right clicking the Fields and choosing "View Hidden"
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |