Forum Discussion

vensj's avatar
vensj
New Member
1 year ago
Solved

There was an error when processing the data in the dataset.

Everything works fine in power bi desktop version, but once published i keep geeting this error message. my data is linked through a sharepoint.
Data source errorFile contains corrupted data.. The exception was raised by the IDbCommand interface. Table: Asset.
Cluster URIWABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
Activity ID1fd96035-7d9f-4803-852e-cf9eae31752e
Request IDa2ead200-a2e0-b9da-8825-cf1d0810dd3c
Time2025-02-25 15:55:03Z

4 Replies

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support

    Hi vensj,

    Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you, Idrissshatila,for your valuable input regarding the issue.

     

    After reviewing the details you provided, I have identified the alternative workarounds that may help resolve the issue. Please follow these steps:

     

    • Verify that the data in the SharePoint source is intact by opening the file directly from SharePoint and checking its integrity.
    • Ensure you are using the latest version of Power BI Desktop, as updates often include fixes for known issues.
      What's new in the latest Power BI update - Power BI | Microsoft Learn
    • In Power BI Desktop, navigate to File > Options and settings > Options. Under GLOBAL, select Data Load, and then click Clear Cache.
    • Go to File > Options and settings > Data source settings, and then select Clear Permissions to remove any cached credentials. Confirm that you have the necessary permissions to access the SharePoint data source. Check with the data source owner or administrator if needed.
    • If the file is corrupted, try re-uploading a fresh copy to SharePoint and update the data source in Power BI Desktop. Ensure your network connection is stable and there are no connectivity issues between Power BI and SharePoint.
    • Create a simple report using the same data source to determine if the issue persists. This can help identify whether the problem lies with the data source or the specific report.

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

     

    Best Regards.

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support

      Hi vensj,

       

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

       

      Thank you.