Forum Discussion

Djilali's avatar
Djilali
Regular Visitor
1 year ago
Solved

Power BI Common Data Service Virtual Table Issue

Hello, we have developped an application based on Dataverse and linked with Virtual Table inside Dataverse, but there is an error when we try to import this kind of table inside a report:   For exa...
Need Help
  • Djilali's avatar
    Djilali
    1 year ago

    Hello, Thank you for your responses,

    For information the solution was to use System table:

     

     Search for the table name in it's plurial name.

    This option allow only use of the table in import mode.

     

    One other option could be the use of Power BI dataflow but I haven't try it out for the moment.

     

    Thank you for your help!

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi Djilali 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Please try the suggestions below. If you continue to experience any issues, feel free to reach out here for further assistance.

Open Power Query > Go to Advanced Editor for the virtual table > Remove all filters and column selections from the query > Click Close & Apply.

Thanks.

 

 

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    Hi Djilali 

    I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

     

  • Djilali's avatar
    Djilali
    Regular Visitor
    1 year ago

    Hello,

    I've made no modification except for the table selection:

     

    Best regards,

    Djilali.

    • v-priyankata's avatar
      v-priyankata
      Community Support
      1 year ago

      Hi Djilali 
      Removing the filters & column selections from the query may fix yoour issue, Did you have a chance to review my suggestion above? Have you tried it yet? Please let us know if you are still experiencing any issues after trying it.

      Thanks

      • Djilali's avatar
        Djilali
        Regular Visitor
        1 year ago

        Hello, I haven't applied any filter and I'm not sure what the column selection means but I havent made any modification.

        There are only two operation, the connexion to the source:

         

         

        And the navigation to the dataverse virtual table:

         

         

        It's the brut data that I tried to import.