Forum Discussion
Error: Unrecognized fields in visual in powerBI
Hi Guys,
Sorry for the delayed response. We finally figured out the problem here.
If you have multiple cubes in one database and have some common dimension/s across the cubes, powerBI doesn’t connect back to the correct cube.
For e.g., in the screenshot, I have a database (Database_A) and 3 cubes. All 3 cubes have date dimension. While adding a datasource to the enterprise gateway, it asks to enter only the database name and not the cube to which we would like to connect. I published a powerBI dataset for Cube2 and when I use the date & a measure in a report, PowerBI doesn’t understand the cube to which I’m connecting and it reads some other Cube (say Cube1 or Cube3). The error was since Cube1/Cube3 doesn’t have the measure that I have used in my report. This is the reason why it works sometime as it might get the correct cube being used sometimes and doesn’t most of the time.
To me it’s more a powerBI issue as it doesn't reslove back to the correct cube.
Regards,
Anjana
Hi Guys,
Sorry for the delayed response. We finally figured out the problem here.
If you have multiple cubes in one database and have some common dimension/s across the cubes, powerBI doesn’t connect back to the correct cube.
For e.g., in the screenshot, I have a database (Database_A) and 3 cubes. All 3 cubes have date dimension. While adding a datasource to the enterprise gateway, it asks to enter only the database name and not the cube to which we would like to connect. I published a powerBI dataset for Cube2 and when I use the date & a measure in a report, PowerBI doesn’t understand the cube to which I’m connecting and it reads some other Cube (say Cube1 or Cube3). The error was since Cube1/Cube3 doesn’t have the measure that I have used in my report. This is the reason why it works sometime as it might get the correct cube being used sometimes and doesn’t most of the time.
To me it’s more a powerBI issue as it doesn't reslove back to the correct cube.
Regards,
Anjana