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 
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.

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

      Hi Djilali 

      I hope you have raised support ticket. 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.

      Thanks.