- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to avoid preview is Evaluating in Power BI Desktop
Hey everyone,
I'm currently working on developin a custom connector in Power BI desktop and have noticed a particular behavior when the checkbox of a table is clicked in navigator. Upon clicking, a "Preview is Evaluating..." message appears on the right side of the navigator, and it takes approximately 5-10 minutes for a truncated table to load. This loading message can be misleading for users, as they might assume they need to wait for the preview when they could instead click on "Load" to directly load the table into the data pane.
Are there any techniques or settings within the Power BI connector code or Power BI desktop application that could help mitigate this issue?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is no remedy. Whenever you change the meta data this will happen.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@lbendlin
Thank you for your response. I discovered that the Preview feature is also impacting the performance of the connector. Using the diagnostics tool, I found that the same API is called multiple times. I suspect these multiple calls are due to the Preview and data loading processes. The connector performs over 500 API calls, transforming each call into a table, which significantly affects performance. My question is: if we cannot stop this behavior, is there a way to limit the Preview data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are there any techniques or settings within the Power BI connector code or Power BI desktop application that could help mitigate this issue?
Yes, but they are not practical. The essence of the technique is "Never ever change the meta data ever again".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@lbendlin
Thank you for your response. Could you please clarify your explanation? I'm having difficulty understanding your point. I'm looking for a way to bypass the Preview of the table in Navigator when loading a table in Power BI Desktop via a custom connector.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is no remedy. Whenever you change the meta data this will happen.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-09-2024 01:56 AM | |||
06-13-2024 07:42 AM | |||
08-27-2024 07:31 PM | |||
Anonymous
| 07-30-2024 12:31 AM | ||
06-21-2023 12:37 AM |