I have created a query using Desktop version which connects to both Azure App Insight and Azure SQL DB.
The App Insight query was created from Analytics site, and exported to Desktop vesion using M language.
I published the query to Power BI Personal version from the Desktop version and created a report from it. I pinned the report to a dashboard in order to share it with other people and have it refreshed on schedule (once a day is good enough).
When I first published the report I chose OAuth authentication method but after that it disappeared from the authentication options of the datasource.
The report is not refreshed automatically and when I check it I discover that I need to re-enter the credentials.
I enter them (only options are 'Windows' and 'Basic' so I choose Basic) and it is working. But after a few hours it is again asking for credentials.
Here are some of the errors I received:
When trying to use a personal gateway:
Please try again later or contact support. If you contact support, please provide these details.
From Data Source Credentials section:
Last refresh failed: Mon Dec 05 2016 10:56:28 GMT+0200 (Jerusalem Standard Time)
There was an error when processing the data in the dataset.Hide details
|Data source type:|
|Processing error:||The data source kind doesn't support the credential type. Data source kind: SQL. Credential type: OAuth2.|
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Hide details
|Time:||Mon Dec 05 2016 10:58:26 GMT+0200 (Jerusalem Standard Time)|