cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ChristoherMuehl
Frequent Visitor

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 yet, the RestAPI connector from CData came to my mind.

The DSN configuration of the connector looks like this:

2019-04-03 18_17_39-CData Power BI Connector for REST - DSN Configuration.png

 

If I now want to connect to this connector in PowerBI Desktop, I get the following error message:

2019-04-03 18_26_06-Verbindung nicht möglich.png

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

1 REPLY 1
TeigeGao Solution Sage
Solution Sage

Re: Call TimeSeriesInsights with RestAPI

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors