Forum Discussion
PowerBI SCCM Template errors
Hi,
I am very new to powerbi, and I don't have much SQL background as I am an Infra kind of person. I stumbled upon the SCCM template that Microsoft has provided in GITHUB.
One of them is an EXE version, in which I haven't tried because there's much policy that I cannot go thru the process of completing the setup.
The other one is a powerbi template and this is the one that I tried to explore. The instruction seems to be straight forward, change your data source and credentials pointing to your SQL server and it should work. I have done this so and I noticed the in the queries, there are total of 17. The first 2 seems to be referring to a variable SQL server and SQL database. I didn't modify this.
The next 15 seems to be the actual data that the report is trying to pull. Each one of them have a warning Icon.
I managed to fix it by editing the settings and point it to the database. (But I am not sure if this is the right thing to do)
Among these queries, there are 2 that I just don't know how to fix.
After trying to research if there is a quick way I can fix it, it turns out that I don't have the SQL knowledge to understand what is going on.
This is what it looks like in the advance editor
I am hoping I can get some help by posting here.
Thanks in advance.
3 Replies
i have also pull this template from here and opened it with powerbi
Hi cimpercee,
AFAIK, the template will parameterize your connection strings and invoke them at multiple subquery tables if your data source structure is similar to the template author.
For your scenario, it seems like these subquery tables can't redirect to correspond sub-tables from your database. You need to manually fix these redireictions to invoke correctly detail level tables.Regards,
Xiaoxin Sheng
SCCM has been upgraded to a newer version, Power Bi can not query the database as before.
I suggest you do a new file and refer to the original version of the file.
