which all i am allowed import in power bi?

[Anonymous]

which all i am allowed import in power bi?

FileName   FileType       Size                  Location
F1               TSV              49 MB               Microsoft oneDrive
F2                XML             100 MB             Microsoft oneDrive FOR BUSINESS
F3                JPG               5 MB                 Local

Provide any link that can explain why yes or no

[v-juanli-msft]

Hi @Anonymous 

We could connect to OneDrive for Bussiness or Personal directly with Power BI Desktop.

https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

https://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-support-for-OneDrive-Personal-as-data-source/td-p/129125

However, it seems only successful for Excel files or folders

So, i provide the workaround for Question2.

As other questions, i am testing for them, i will tell you if there are any workarounds for them.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @Anonymous 

As tested,

For question 2,

First, i sync the xml file in OneDrive For Business to local drive by following this article ,

Second, Connect to XML file with Power BI Desktop:

Get Data->File->Xml->find one drive folder

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

---

Thanks for the Ans. So there is a workaround to do this but we con't connect to OneDrive For Business directly? Is that right?

@v-juanli-msft wrote:

Hi @Anonymous 

As tested,

For question 2,

First, i sync the xml file in OneDrive For Business to local drive by following this article ,

Second, Connect to XML file with Power BI Desktop:

Get Data->File->Xml->find one drive folder

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

---