Data Exchange Issue

[cconley530]

So, I just watch a video showing a person linking a Revit Data Exchange link into Power BI and it works just fine. I however have tried the same thing, and I continuously get this error (The data in the preview has been truncated due to size limits) no matter how many different Data Exchange's I try it never works. FYI It does not give me the option to Load it just stops, I know everything I have read says to just load the datga anyways, No option to load.

[v-pagayam-msft]

Hi @cconley530 ,

Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[v-pagayam-msft]

Hi @cconley530 ,
Thank you @Akash_Varuna for the helpful response!
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members in the community who have similar problems as yours to solve it faster.
Thank you.

[Akash_Varuna · Accepted solution]

Hi @cconley530  I think the preview size is limited to 1 GB per data source in Power BI's import mode. If the dataset exceeds this, try disabling the data preview in Options > Data Load to avoid truncation issues. For DirectQuery, there’s no specific size limit, but performance depends on the data source and query complexity. Reducing the dataset size or using DirectQuery can help bypass these limits.