Forum Discussion

cconley530's avatar
cconley530
New Member
1 year ago
Solved

Data Exchange Issue

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 ...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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.

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

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.