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.
Running Power BI 2.70.5494.761 64-bit june 2019.
When I open the OData 4 feed on URL https://app.office365-apps.com/powerbi/bridge/v9/odata4, this message is displayed. Download from browser with basic authentication attached as v9.json. Note that the column list associated with it is very large.
The OData 4 feed on URL https://app.office365-apps.com/powerbi/bridge/v8/odata4 is similar, but less extensive. Download attached as v8.json.
What does this error mean?
Solved! Go to Solution.
Found cause of problem. We have several tables with 10.000+ columns (they are on Invantive SQL, which has higher limits than normal). Power BI seems to fail with "The type of the current preview is too complex to display." when a table has more than approximately 3.000 columns.
Restricted to 3.000 columns for now.
Found cause of problem. We have several tables with 10.000+ columns (they are on Invantive SQL, which has higher limits than normal). Power BI seems to fail with "The type of the current preview is too complex to display." when a table has more than approximately 3.000 columns.
Restricted to 3.000 columns for now.
Hi @monty ,
Here is a similar thread for your reference. Please check if the suggestion mentioned in it work for your scenario.
Best regards,
Yuliana Gu
Hi Yuliana Gu, thanks for your suggestion!
Sadly enough the JSON files (see attached files) have no relationships, so the similar error on the referred to issue has no correlation with this cause. Nonetheless thanks!
Regards,
Guido
Hi @monty ,
Maybe you can create a support ticket for further analysis.
Regards,
Yuliana Gu
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |