download a report based on a streaming data set

[eddd83]

I created a Microsoft forms survey and a power automate flow to feed the MS forms data into my power bi report. However, I would like to download this power bi report to work on it thru power bi desktop instead of using the edit option in power bi service. Unfortunately, the download option is grayed out and when I create a new .pbix file, there's no option in "get data" for Microsoft forms.

Help?

[v-robertq-msft]

Hi, @eddd83 

Keep in mind: You can only download pbix files which are created in the desktop and published to service. So you can not download it as pbix file. I suggest you to get data from Power BI dataset in Power BI desktop, then you can connect live to the dataset and create your report in desktop.

This document explains how to do this in detail:

https://iterationinsights.com/article/importing-ms-forms-responses/

More limitations of downloading as pbix in service

Best Regards,

Community Support Team _Robert Qin

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

[eddd83 · Accepted solution]

nevermind, I figured it out. I found my online data set via "Get Data --> Power BI datasets"