Sharepoint refresh - 3 lists - no data

I'm not sure how to properly diagnose this and would like some pointers please. I have a dashboard that is connected to 3 x Sharepoint lists, they all are provided from the same Office 365 tennan...

Need Help

dgwilson
8 years ago

And here's the follow up.
https://community.powerbi.com/t5/Issues/Yes-No-field-value-changing-based-on-how-it-is-refreshed/idi-p/234496

I can confirm this works.

Anonymous

Not applicable

8 years ago

Hi dgwilson,

Does your report contains records, is this blank issue only appears on dashboard? Can you please share you refresh history?

In addition, it sound like you are use oauth mode to link your datasources, but it not appears on power bi service data source credentials authorization mode?

If this is a case, any advanced operations in your query? Such as: append/merge, reference other queries, invoke custom functions.

Regards,

Xiaoxin Sheng

dgwilson

Resolver III

8 years ago

Hi Anonymous thanks for the follow up.

Refresh history is in the image below. - I've never seen a failure.

Here's the first tab of the dashboard in PBI Desktop - as I expect to see it:

And here it is after being published as an application and refreshed.

I'm pretty sure the only reason one customer is there is becasue the selection is cached.

The source data comes from here (obviously I"ve changed xxxxxx):

SharePoint.Tables("https://xxxxxxx.sharepoint.com/sites/xxxxxxxxxxxx", [ApiVersion = 15])

Actually this might be more useful for you:

let
    Source = SharePoint.Tables("https://xxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", [ApiVersion = 15]),
    #"32d9d393-f9e2-4ead-b5cc-70e94b7cefa7" = Source{[Id="32d9d393-f9e2-4ead-b5cc-70e94b7cefa7"]}[Items],
    #"Renamed Columns" = Table.RenameColumns(#"32d9d393-f9e2-4ead-b5cc-70e94b7cefa7",{{"ID", "ID.1"}, {"Title", "Customer Name"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Logo URL", type any}}),
    #"Expanded Logo URL" = Table.ExpandRecordColumn(#"Changed Type", "Logo URL", {"Description", "Url"}, {"Logo URL.Description", "Logo URL.Url"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Logo URL",{{"Logo URL Long", type text}})
in
    #"Changed Type1"

Below is the Credentials screen when I Open it - seems it always defaults to displaying Anonymous