Forum Discussion
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 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.
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!
9 Replies
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.Hi Djilali
I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hello,
I've made no modification except for the table selection:
Best regards,
Djilali.
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
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.
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!
