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.
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 yet, the RestAPI connector from CData came to my mind.
The DSN configuration of the connector looks like this:
If I now want to connect to this connector in PowerBI Desktop, I get the following error message:
Did I forget something during the configuration?
I have done an app registration in Azure to get the ClientSecret and the ClientId.
The API should be queried via DirectQuery and the ResultSet of the API call is probably a JSON.
If the connection works, do I have a way to parse the json in Direct Query mode in PowerBI?
Thank you in advance!
Best regards,
Christopher
Hi @ChristoherMuehl ,
>>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
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.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |