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.
Hi,
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:
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. |
Cluster URI: | WABI-WEST-EUROPE-redirect.analysis.windows.net |
Activity ID: | 2d075996-ea69-46ef-a850-35c09badee92 |
Request ID: | 63a77c23-cfe1-b4e1-7bdc-a7f9466169a8 |
Time: | 2016-12-05 08:56:28Z |
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Hide details
Activity ID: | 2d075996-ea69-46ef-a850-35c09badee92 |
Request ID: | 394fa4c1-35a4-0042-e159-7aed7cfdf67d |
Status code: | 200 |
Time: | Mon Dec 05 2016 10:58:26 GMT+0200 (Jerusalem Standard Time) |
Version: | 13.0.1700.720 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.