Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

MS forms X Power BI - Bi not recognizing Ratings table

Hello,

I am new to PowerBi and connected MS forms to BI via the web connector. 

 

All data tables are being pulled except this one, it does not display the rating only pulls in number of responses. Any suggestions for understanding this. 

Thank you 

  • Hi Anonymous ,

     

    According to your description, here is my suggestion.

    When you use Desktop and the file you want to import is on the web, you must import the file by using the web connector.

    And there are some file types which are supported by the web connector: Access database, CSV documentation, Excel workbook, JSON, text file, HTML page, XML table, PDF.

    You can check whether the rating table is supported and I think you can click “more details” to view the table.

     

    Please refer to the following document.

    Power Query Web Connector - Power Query | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    According to your description, here is my suggestion.

    When you use Desktop and the file you want to import is on the web, you must import the file by using the web connector.

    And there are some file types which are supported by the web connector: Access database, CSV documentation, Excel workbook, JSON, text file, HTML page, XML table, PDF.

    You can check whether the rating table is supported and I think you can click “more details” to view the table.

     

    Please refer to the following document.

    Power Query Web Connector - Power Query | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.