Azure-docs: Enable refresh from Power BI service

[DannyAguirre]

This works great on Desktop. However.....We need a solution that allows API authentication when you publish the report up to the Power BI Service. I have tried all sorts of authentications and cannot get this to work. I know this has been voted in Power BI suggestions to allow users to schedule refresh the reports/dashboards.

Error:
Expression.Error: The 'Authorization' header is only supported when connecting anonymously.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: ffd6c661-3889-e5bf-0b33-d84eff80e8a3
• Version Independent ID: 7b185544-3127-394d-c621-4eaa9088cd4a
• Content: Tutorial: Text Analytics with Power BI - Azure Cognitive Services
• Content Source: articles/cognitive-services/text-analytics/tutorials/tutorial-power-bi-key-phrases.md
• Service: cognitive-services
• GitHub Login: @LuisCabrer
• Microsoft Alias: luisca

[Mike-Ubezzi-MSFT]

@BiGuRuNot Thanks for the feedback! I have assigned the issue to the content author to evaluate and update as appropriate.

[LuisCabrer]

Please assign to @ashmaka

[tchristiani]

@Mike-Ubezzi-MSFT the engineering team has responded that this is an issue for the PowerBI team not the Text Analytics team. Please reassign to the appropriate contact for PowerBI. Thank you.

[tchristiani]

@Mike-Ubezzi-MSFT please assign to the appropriate PowerBI resource to respond to this product request.

[YutongTie-MSFT]

@SarinaJoan Hi Sarina, can you please check this issue? If necessary, I can help to move it into PowerBI repo. Please tell me if anything I can help.

[tchristiani]

@YutongTie-MSFT this issue is not a Cognitive Services issue. This is a PowerBI issue. Please move it to their repo. Thank you.

[YutongTie-MSFT]

@BiGuRuNot
Thank you for taking the time to share your product and documentation feedback with us. Your input is valued because it helps us create the right documentation for our customers.

Due to the volume of issues in our queue, our policy is to close issues that have been inactive for the last 90 days. We hope to continue hearing from you. Thank you.

[mohsena67]

Any update on this?
How can we refresh data in Power BI Service?

[tchristiani]

@mohsena67 you should open this issue in the PowerBI repo.

[mohsena67]

Actually I was able to resolve it. I made the permission level of the cognitive services data source to anonymous and “public” in power BI service and permission level of other sources which were used to combine with the cognitive services applications to public too. Also I ticked the checkbox for skipping tests and now I can refresh my cognitive services sources in power BI service without any problem.

[YutongTie-MSFT]

@BiGuRuNot Thank you for sharing you solution. I will put a small notice for customers if applicable.

[radicalhqer]

Actually I was able to resolve it. I made the permission level of the cognitive services data source to anonymous and “public” in power BI service and permission level of other sources which were used to combine with the cognitive services applications to public too. Also I ticked the checkbox for skipping tests and now I can refresh my cognitive services sources in power BI service without any problem.

Could you please elaborate more on the specifics. It still wont work for me. The whole point of Cognitive Services API is to use it in PowerBI web not in desktop mode.

[mohsena67]

Radicalhqer,
Yes but you need to build your reports in Power BI Desktop first then you publish it to the web / Power BI Service. Update permission levels of all tables connected to the API cognitive service function/table, to “public”. First do this in the Desktop, then once published you can do this in the Web / Power BI Service ...

[radicalhqer]

Yes, I had built it on PBI desktop and yes, I have set it up as "Anonymous" and "Public".

[mohsena67]

If you give me more info, I can help you. Does it work in Power BI Desktop when you make all the data sources settings to public.