Forum Discussion
Call TimeSeriesInsights with RestAPI
Hello community, I am currently trying to visualize data from Azure Time Series Insights in Power BI. As there is currently - to my knowledge - no connector for Time Series Insights for PowerBI ...
Hi Anonymous ,
>>If the connection works, do I have a way to parse the json in Direct Query mode in PowerBI?
We can use the Json.Document function to return the contents of a JSON document. Then we can expand the data, for more information, please refer to this blog: https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/
But based on the error message, it looks like that we cannot get data from Azure Time Series directly, as a workaround, we can create another source and import data to this source, then let PowerBI access to this source.
Best Regards,
Teige