Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
I have a report (built in desktop). When it gets published a card that has data from a sharepoint list - is showing the correct details. However after a scheduled refresh - the card is BLANK.
Doing a refresh in the service report makes no difference - doing a refresh of the Semantic model makes no difference - the only way to get my data back is to refresh the desktop report and rebublish.
The other visuals which pull dta from various other sources all work as expected in the service report after a scheduled refresh
Struggling to find a resolution - any help would be gratefully received
Helen
Solved! Go to Solution.
Think I have found my issue
Cause:
In Power BI Desktop, a column is created in power query using the M function: Date.IsInPreviousMonth(dateTime as any).
The data returned is nullable logical but you didn't change the type to true/false.
Then you are applying a filter=true to that field in Power BI Desktop.
When the report is published to Power BI Service and Refreshed, the service is returning -1/0 for the nullable logical, thus the report presents (Blank) values because the filter applied is set to true.
Moral of the story - always check your data types when creating columns
Hi Christine - thanks for the suggestions
All looked good and we could see the data actually being pulled through - just not displaying in the visuals
We went back to basics and put in a simpel visual of the sharepoint list into the desktop report with no filter - published - made a change to the data - did a refresh of the Semantic and all was good. It appears our issue is that there is a filter on the visual (in the desktop build) and this is causing our problem.
Now looking into how we can work around this as we need the filters
Think I have found my issue
Cause:
In Power BI Desktop, a column is created in power query using the M function: Date.IsInPreviousMonth(dateTime as any).
The data returned is nullable logical but you didn't change the type to true/false.
Then you are applying a filter=true to that field in Power BI Desktop.
When the report is published to Power BI Service and Refreshed, the service is returning -1/0 for the nullable logical, thus the report presents (Blank) values because the filter applied is set to true.
Moral of the story - always check your data types when creating columns
The only time I've had this issue is when I had the scheduled refresh running with a different account (e.g. service account) and was using the SharePoint list setting "users can only see their own items". If you're doing this combination of things, make sure the account that is running the refresh has "full control" permission on the list to bypass the setting.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.