Power BI Common Data Service Virtual Table Issue

[Djilali]

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 example we have a virtual table named dim_country:

It is well imported and all the data is available:

But when I hit apply and close I have this error, and the table is not imported in the report:

crf19_dim_country
Échec de l'enregistrement des modifications sur le serveur. Erreur retournée : « Erreur OLE DB ou ODBC: [DataSource.Error] Web.Contents n'a pas réussi à obtenir le contenu de « https://orgd6d72f20.crm12.dynamics.com/api/data/v8.2/crf19_dim_countries?%24filter=crf19_dim_countryid%20ge%2000000001-0000-0000-0000-000000000000%20and%20crf19_dim_countryid%20le%2000000103-0000-0000-0000-000000000000&%24select=crf19_geoarea%2Ccrf19_area%2Ccrf19_region%2Ccrf19_continent%2Ccrf19_groupingstakeholder%2Ccrf19_country%2Ccrf19_countrycode%2Ccrf19_pmslevel2%2Ccrf19_countryen%2Ccrf19_mgmtcluster%2Ccrf19_countryfr%2Ccrf19_externalprimarykey%2Ccrf19_dim_countryid%2Ccrf19_language%2Ccrf19_territory%2Ccrf19_mgmtarea%2Ccrf19_submgmtarea%2Ccrf19_shippingdelay%2Ccrf19_pmslevel3 » (400) : Bad Request.  ».
crf19_Registration
Échec de l'enregistrement des modifications sur le serveur. Erreur retournée : « Erreur OLE DB ou ODBC: [DataSource.Error] Web.Contents n'a pas réussi à obtenir le contenu de « https://orgd6d72f20.crm12.dynamics.com/api/data/v8.2/crf19_dim_countries?%24filter=crf19_dim_countryid%20ge%2000000001-0000-0000-0000-000000000000%20and%20crf19_dim_countryid%20le%2000000103-0000-0000-0000-000000000000&%24select=crf19_geoarea%2Ccrf19_area%2Ccrf19_region%2Ccrf19_continent%2Ccrf19_groupingstakeholder%2Ccrf19_country%2Ccrf19_countrycode%2Ccrf19_pmslevel2%2Ccrf19_countryen%2Ccrf19_mgmtcluster%2Ccrf19_countryfr%2Ccrf19_externalprimarykey%2Ccrf19_dim_countryid%2Ccrf19_language%2Ccrf19_territory%2Ccrf19_mgmtarea%2Ccrf19_submgmtarea%2Ccrf19_shippingdelay%2Ccrf19_pmslevel3 » (400) : Bad Request.  ».
crf19_Registration_Distributor
Échec de l'enregistrement des modifications sur le serveur. Erreur retournée : « Erreur OLE DB ou ODBC: [DataSource.Error] Web.Contents n'a pas réussi à obtenir le contenu de « https://orgd6d72f20.crm12.dynamics.com/api/data/v8.2/crf19_dim_countries?%24filter=crf19_dim_countryid%20ge%2000000001-0000-0000-0000-000000000000%20and%20crf19_dim_countryid%20le%2000000103-0000-0000-0000-000000000000&%24select=crf19_geoarea%2Ccrf19_area%2Ccrf19_region%2Ccrf19_continent%2Ccrf19_groupingstakeholder%2Ccrf19_country%2Ccrf19_countrycode%2Ccrf19_pmslevel2%2Ccrf19_countryen%2Ccrf19_mgmtcluster%2Ccrf19_countryfr%2Ccrf19_externalprimarykey%2Ccrf19_dim_countryid%2Ccrf19_language%2Ccrf19_territory%2Ccrf19_mgmtarea%2Ccrf19_submgmtarea%2Ccrf19_shippingdelay%2Ccrf19_pmslevel3 » (400) : Bad Request.  ».
crf19_Registration_Items
Échec de l'enregistrement des modifications sur le serveur. Erreur retournée : « Erreur OLE DB ou ODBC: [DataSource.Error] Web.Contents n'a pas réussi à obtenir le contenu de « https://orgd6d72f20.crm12.dynamics.com/api/data/v8.2/crf19_dim_countries?%24filter=crf19_dim_countryid%20ge%2000000001-0000-0000-0000-000000000000%20and%20crf19_dim_countryid%20le%2000000103-0000-0000-0000-000000000000&%24select=crf19_geoarea%2Ccrf19_area%2Ccrf19_region%2Ccrf19_continent%2Ccrf19_groupingstakeholder%2Ccrf19_country%2Ccrf19_countrycode%2Ccrf19_pmslevel2%2Ccrf19_countryen%2Ccrf19_mgmtcluster%2Ccrf19_countryfr%2Ccrf19_externalprimarykey%2Ccrf19_dim_countryid%2Ccrf19_language%2Ccrf19_territory%2Ccrf19_mgmtarea%2Ccrf19_submgmtarea%2Ccrf19_shippingdelay%2Ccrf19_pmslevel3 » (400) : Bad Request.  ».

What can I do to import these tables in my report.

Thank you for your help,

Djilali.

[Djilali · Accepted solution]

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!

[Djilali]

Hello, Thank you for your suggestion,

I'm currently off office, I'll get back to you next week so we can pursue this case.

Have a good day,

Djilali.

[v-priyankata]

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.

[Djilali]

Hello,

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

Best regards,

Djilali.

[v-priyankata]

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]

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]

Hi @Djilali 
We have provided you the possible root causes. we regret the inconvenience caused Kindly raise a support ticker here How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn so that they can go through the data from the source along with the settings in the power bi and help you in resolving your issue quickly.

Thanks

[v-priyankata]

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.

[v-priyankata]

Hi @Djilali 

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