cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Azure Cost Management - Empty tables and expression.error

hi,

I have wotrked hard to use the Cost Management connector to visualise the data, however I can only see the contents of two tables (RI Recommendations), whilst the rest is causing three types of issues:
3 tables connect ok, but they are empty (no data is showing).
2 tables do not connect becuase of
"Expression.Error: We cannot convert the value null to type Record.
Details:
Value=
Type=[Type]"

3 tables do not connect becuase of a different "Expression.Error: Access to the resource is forbidden."
crown azure table.jpg
To connect to Cost Management I follow the directions here:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management
To solve this issue I have thus far tried:
1. clearing cache
2. clearing global and local connections
3. deleting global and local connections

4. disabling the function of “ Automatically detect column types and headers for unstructured sources” in options.


I can see the data in question, without issues in the Azure Portal as you can see below, so what am I doing wrong?
crown azure portal.jpg

3 REPLIES 3
lbendlin
Super User
Super User

If you have a Power BI Pro license you can raise a ticket with Microsoft for this issue.

Support | Microsoft Power BI

lbendlin
Super User
Super User

Go to Data Source Settings and clear all Global permissions. Then try to connect again, this time specifying the same authentication method you use on the web page (organizational, I guess)

Anonymous
Not applicable

Thanks, but sadly that didn't achieve anything.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!