Forum Discussion

Alexsubsub's avatar
Alexsubsub
Frequent Visitor
3 years ago

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

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

 

 

 

Need Help

3 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support
    3 years ago

    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's avatar
      Alexsubsub
      Frequent Visitor
      3 years ago

      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