Invalid URI: The hostname could not be parsed.

[cgreenholt]

A few days ago i started getting:

• Processing errorInvalid URI: The hostname could not be parsed.
• Cluster URIWABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
• Activity IDe14f915c-c705-4a0b-9b9b-41bb0a1c2942
• Request ID4f0096bb-b96e-4b66-ad5b-1bf3699daff8
• Time2022-03-22 08:17:58Z

specifically using the Microsoft.Consumption/reservationTransactions link.

I have two other consumption reservation links that are working fine.

Obviously this has broken my report as it has not been able to refresh successfully for 3 days now.

Is anyone else having this problem?

Any ideas on how to fix it?

[cgreenholt]

1. Does the issue only appear in Power BI Service?
No. This exists in both Desktop and Service

2. What's your Power BI Service and client version?
Desktop = Version: 2.103.661.0 64-bit (March 2022)

Service version13.0.17952.42
Client version2203.3.10543-train

3. What's your data source?
Azure Cost Management

4. Can this issue be reproduced? What're the detailed steps?
Easily. When I choose "Azure Cost Management" as my source, I can select and load ANY table in that source EXCEPT "RI Charges". That fails immediately by just selecting it and trying to get the "preview". It gives the "Invalid URI: The hostname could not be parsed." error. This initially showed up in the Service when my daily refresh started failing (Sunday, March 20). In my mind.this is definitely with Microsoft since I can load any of the table data from that source except that one. It had worked for literally years previously and I have not made ANY changes in the past 3 months.

5. Do other colleagues or other devices meet the same issue?
I am the only one using this source.

[amitchandak]

@cgreenholt , Create a new connection with same details and check, if that works. then clear permission under trasform data -> data source setting and try again.

In power bi service provide details under settings again

[cgreenholt]

@amitchandak Thank you for that info. I tried but it does not "fix" the issue. I can sort of force it to the point that it loads, but in the table, one column has errors (of 11 rows, it says 4 rows have errors). I obviously can not remove or keep, but I tried to remove empty and remove duplicates, but that still does not help. Once I attempt to refresh again, ir fails with the same "invalid URI" error. Any other thoughts?

[Icey]

Hi @cgreenholt ,

Could you share us more details? For example,

1. Does the issue only appear in Power BI Service?

2. What's your Power BI Service and client version?

3. What's your data source?

4. Can this issue be reproduced? What're the detailed steps?

5. Do other colleagues or other devices meet the same issue?

Best Regards,

Icey