PowerBI Service can't convert binary file while Desktop can - Excel

[Alexsubsub]

Hi everyone,

I am struggling with an error with PowerBI Services. I have a report that is well refreshed on PowerBI Desktop (sources are databricks & sharepoint online for 2 excel files) but not in PowerBI Services. I don't know why.

The error returned is: We cannot convert the value "[Binary]" to type Binary.

The only moment were I convert binary content are the when I get content of 2 excel files I am looking for on two private SharePoint sites. However it works like a charm on PowerBI desktop.

I don't understand why this is not working on PowerBI Services. The connection of both sharepoint sites is settled like this:

Have you seen such error? 

This is for example the function used to convert the excel file into a table on Power Query:

(auto generated)

The parameter1 is:

Thanks!

Alexandre

[v-yinliw-msft]

Hi @Alexsubsub ,

If I understand your idea correctly, you have two excel tables, one is in databricks and the other is in sharepoint online.

Could you please test that change the private level from Private to Organizational in the first picture?

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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

[Alexsubsub]

Hi,

Thanks for your message. The 2 excel files are on 2 different SharePoint Sites. 

I already tested that, on both SharePoint Sites, also switching to "Public" and to "None" but this is still there. 

How do you see the private level of a SharePoint Site? Both of them are

It's a bit confusing.

Kind regards,

Alex

[Alexsubsub]

FYI, I have found this : Solved: Re: Underlying error message: We cannot convert th... - Page 2 - Microsoft Power BI Communit...

but this is a workaround solution by using csv files. What can I do to use excel file instead?