Power Bi Service - Refresh not possible

[Jerome_C63]

Hi community,

I need help because I can't find the solution.

I've created a complete Dashboard to retrieve information from the Web (MS Website) and also data from Intune via an application registered on my tenant (parameters used = Tenant ID, Apps ID and Secret ID).
In Power BI Desktop, everything works perfectly, but once published in Power BI Service, things get complicated because it's impossible to do a simple refresh.

At first there was a problem with credentials, so I went to the settings level and then Managed Connections and Gateways to play around with anonymous authentication (with or without connection verification) and also with the level of privacy. In short, nothing works.

So I started from 0 by trying to retrieve data from a Microsoft web page (see the code below). It's not very complex and it updates nicely in Power Bi Desktop.

Now, once I've published it in Power Bi Service, I can't refresh it even though it's a simple web page with anonymous access to public data.

let
// Step 1 : Get data from Microosft WbeSite
Source = Web.BrowserContents("https://learn.microsoft.com/en-us/entra/identity/users/licensing-service-plan-reference"),

// Step 2 : Extract table data from Microosft WbeSite
ExtractedTableFromHtml = Html.Table(Source, {{"Column1", "DIV.table-wrapper.has-inner-focus > TABLE.table.table-sm.margin-top-none > * > TR > :nth-child(1)"}, {"Column2", "DIV.table-wrapper.has-inner-focus > TABLE.table.table-sm.margin-top-none > * > TR > :nth-child(2)"}, {"Column3", "DIV.table-wrapper.has-inner-focus > TABLE.table.table-sm.margin-top-none > * > TR > :nth-child(3)"}, {"Column4", "DIV.table-wrapper.has-inner-focus > TABLE.table.table-sm.margin-top-none > * > TR > :nth-child(4)"}, {"Column5", "DIV.table-wrapper.has-inner-focus > TABLE.table.table-sm.margin-top-none > * > TR > :nth-child(5)"}}, [RowSelector="DIV.table-wrapper.has-inner-focus > TABLE.table.table-sm.margin-top-none > * > TR"]),

// Step 3 : Transformation operations
PromotedHeaders = Table.PromoteHeaders(ExtractedTableFromHtml, [PromoteAllScalars=true]),
ChangedType = Table.TransformColumnTypes(PromotedHeaders,{{"Product name", type text}, {"String ID", type text}, {"GUID", type text}, {"Service plans included", type text}, {"Service plans included (friendly names)", type text}}),
AddIntuneColumn = Table.AddColumn(ChangedType, "Intune Included", each
if [Service plans included] <> null
and (Text.Contains(Text.Lower([Service plans included]), "intune_b")
or Text.Contains(Text.Lower([Service plans included]), "intune_a")
or Text.Contains(Text.Lower([Service plans included]), "intune_s")
or Text.Contains(Text.Lower([Service plans included]), "intune_edu")
)
then "Yes" else null),

RenameColumns = Table.RenameColumns(AddIntuneColumn,{{"GUID", "_SkuId"}}),
FinalRows = Table.TransformColumnTypes(RenameColumns,{{"Intune Included", type text}})
in
FinalRows

In the "Managed and Connections Gateway", i checked the status and it's online.

I have this error below and i don't know how to solve it.

Thanks in advance for your help

[v-venuppu]

Hi @Jerome_C63 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @Jerome_C63 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[BertyLurch · Accepted solution]

In your semantic model settings, is it trying to use the gateway? You'll need to either force it to off like the example here, or if you leave it on - map the connections. I would make sure it's turned off - i dont think either of those connections your using would need a gateway.

Then check the credentials here:

[v-venuppu]

Hi @Jerome_C63 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[lbendlin]

They want you to use a Personal Gateway for some weird reason. Have you considered installing one just to see if that works?  

Power BI Service does not like "Anonymous"  connections much.