Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am able to get the chats on the first page but am trying to bulk load chats into powerbi using this https://developers.livechat.com/blog/how-to-get-livechat-api-data-with-microsoft-excel-or-power-bi/
The transcript query keeps coming up with this error: Expression. Error: We cannot apply operator & to types Text and Date.
Details:
Operator=&
Left=https://api.livechatinc.com/v2/chats?date_from=
Right=1/01/2018
Hi @Anonymous
Can you sahre the M code so that we can see where the issue is.
Looking at the error message you get, you are attempting to concatenate one piece of text ( https://api.livechatinc.com/v2/chats?date_from=) with a date (1/01/2018). Both items in the concatenation should be of type text. So try converting the date type to text by for instance using Text.From( )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.