Forum Discussion

Mongia_Cherif's avatar
Mongia_Cherif
Frequent Visitor
2 years ago

Unable to load data for this visual element

I encountered a problem with the power Bi service when creating the visuals:
all the processing I did on Microsoft Fabric :

 

  •  Data integration from azure SQL DB and API REST using Pipeline;
  •  Storing data in datawarehouse;
  •  Transforming the integrated data using Dataflows Gen2 and storing it in a new datawarehouse;
  •  create the report with the transformed data an error message appears, as shown below.

 

Unable to load data for this visual element

An unexpected Parquet exception has occurred. Class: "ParquetStatusException" Status: "IOError" Message: "Encountered Azure error while accessing lake file, StatusCode = 404, ErrorCode = , Reason = Not Found".

 

Thanks in advance for your help

Any help is appreciated.

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Mongia_Cherif ,

    Based on the error message you've provided, it appears that Power BI is unable to access the data lake file due to a "NotFound" error. This can happen for a number of reasons, such as the file being moved, deleted, or the URL being incorrect. Here are the steps that you can take to troubleshoot and resolve this issue:

    1. Verify the File Path: Ensure that the path specified for the lake file is correct and that the file has not been moved or deleted. You can check this by accessing the file directly through Azure portal or using Azure Storage Explorer.

     

    2. Check Access Permissions: Confirm that the Power BI service has the necessary permissions to access the data lake file. This includes checking the access policies and roles assigned to the Power BI service in Azure.

     

    3. Review Data Gateway Configuration: If you are connecting to the data source through an on-premises data gateway, make sure that the gateway is up to date and properly configured.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Mongia_Cherif's avatar
      Mongia_Cherif
      Frequent Visitor
      2 years ago

      Hi Anonymous 

      I used Microsoft fabric for this solution. I had access to the data in the Microsoft Fabric datawarehouse.
      When I connect to the report it won't work,

      I'll put up some screensheets to show you that the data already exists in microsoft fabric datawarehouse.

       by clicking on new report i get an error :

      And here's the error message

      I'd like to remind you that I had access to data that I got from azure SQL DB and API Rest that I integrated into the microsoft Fabric pipelines, after which I used dataflow for transformation and the final phase of putting them into datawarehouse.

       

      Thanks in advance for your help

      Any help is appreciated.

      • aeelissa's avatar
        aeelissa
        Frequent Visitor
        1 year ago

        Hello Mongia_Cherif , were you able to solve the issue? I'm facing exactly the same!
        Thanks in advance.
        Regards,
        Ahmad