User Profile
RedWineGirl
Advocate I
Joined 4 years ago
User Widgets
Contributions
Re: A preview of this table isn't available - relationships?
Thank you - I did have the same message in the manage relationship window. There were two existing tables Tabke 1 and Table 2 in the report, then brought in the new table, table 3, went to manage relationships and saw the error. Checked the existing relationships (the one that worked between T1 and T2, before I pulled in the new table T3) and it also showed the error. Even after deleting T3 Pulled in both existing tables (as new tables) and it finds the relationship, but I don't want to rebuild the whole dashboard...2.4KViews0likes3CommentsA preview of this table isn't available - relationships?
Hi - normally have no problem with relationships- existing dashboard all ok. Added a new table and now when I look at relationships. I get "A preview of this table isn't available" Refreshed via desktop, both in Transform Data and on Visuals screen but still showing no data on relationships, and even though I know fields match, no data shows on the reports when I use the tables in visuals. Deleted new table and still shows as "A preview of this table isn't available" on existing relationships Any ideas please? Thanks!Solved2.4KViews0likes6CommentsRe: Scheduled report failing as no data during school holidays
We take data from Bromcom, we create reports and there is the option for a live feed, so we have a URL that pulls the data straight from the MIS into PowerBI - using Web connector. As there is no data (live classes today) when the system pulls the data from the MIS, there isn't any data. Hope that makes sense.1.3KViews0likes2CommentsRe: Scheduled report failing as no data during school holidays
The report in Bromcom (a csv that we use as a live feed) only shows lessons today - we can't say within a period - it's all data (we have volume issues) or just today so when I run the report it's blank. The PowerBI error is ..There weren't enough elements in the enumeration to complete the operation.. #table({"Name", "Table"}, {}). </ccon>;<ccon>There weren't enough elements in the enumeration to complete the operation.</ccon>. The exception was raised by the IDbCommand interface. Table: G Todays Student so it's correct in having no data but that stops the refresh. I'm looking at building an alternative report if need be.1.3KViews0likes4CommentsScheduled report failing as no data during school holidays
We have scheduled daily reports from our MIS system into PowerBI. One of the reports is 'student attendance today' so there is no data in holidays so the refresh fails and the schedule stops. Is there a way I can code straight after Source to ignore empty tables? ThanksSolved1.3KViews0likes8Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.