Hi fellow PowerBI users,
I have some trouble with a report of mine. Actually, my colleague that was managing this well... left... In a way you could say that I am being introduced to PowerBI the hard way lol. I like it so far 🙂 but if I can get it solved, my management would greatly appreciate !
So, for about a week my request don't work any more and I can't figure out the reason... At first I assumed a Power BI update made it fail because it was working so far and nothing changed on my side but I checked the updates and it looks like nothing new came up.
Actually, I don't know where to seek for help so I think my question for you would be "why does it fail ?"
To be more specific, I retrieved the report, took a look at it, uploaded it again with my account. I thought I understood most of its content because it reminded me of report builder with which I was already familiar, the difference being the queries which aren't SQL.
This being said, the report is integrated in a SharePoint with daily automatic refresh and it worked for a few weeks without any problem until d-day 😞
Since, I receive the following error; translated, it should give something like : "Impossible to load the data for this visual element".
The source of the error is based on a calculated table for which the error is : "The query referenced calculated table 'viewSites' which does not hold any data because evaluation of one of the rows caused an error."
The request to build this table is :
viewSites = SELECTCOLUMNS( ADDCOLUMNS ( 'smallSites'; "SitePercent"; LOOKUPVALUE ( 'viewDeployementConsolidatedBySite'[SitePercent]; 'viewDeployementConsolidatedBySite'[SiteID]; 'smallSites'[SiteID] ); "DeploymentPercent"; LOOKUPVALUE ( 'viewComputerDeployementStatus'[DeploymentPercent]; 'viewComputerDeployementStatus'[SiteID]; 'smallSites'[SiteID] ) ); "SiteID";[SiteID];"Title";[Title];"Wave";[Wave];"NbComputers";[NbComputers];"SiteCode";[SiteCode]; "SitePercent";INT(VALUE(IF(ISBLANK([SitePercent]); 0;[SitePercent]))); "DeploymentPercent";INT(VALUE(IF(ISBLANK([DeploymentPercent]); 0;[DeploymentPercent]))); "Status";IF(ISBLANK([SitePercent]) && ISBLANK([DeploymentPercent]);"Planned";IF(VALUE([SitePercent])>= 100 && VALUE([DeploymentPercent])>=100;"Done";"In progress")) )
And this request prompts : "Cannot convert the value "-nan" of type Text into type Number"
To be honest, even though I'm a newbie on PowerBI, I think it's only the process of the last query that causes all these troubles. The cofusing part is that my data source didn't change and neither did the processing of it (query/shaping)...
Induced question, how could I share my report to any one with the proper source (=a private sharepoint) ? Can I share my online report with a read access to someone ?
Thank you very much to anyone having any idea !!
Have a good day 🙂
