Power BI services not showing new field from my Store procedure

[kddavis]

I have added new fields to a stored procedure but after refreshing my data in Power BI services they new fields do not show up but the data is refreshed with the new days data.  I connect in Power BI Desktop using Sql 

Get Data

Sql Server

Import

Advanced Options

then I add my sql sp query 

then click on

that is how my data is added

[sergej_og · Accepted solution]

Of course, I recommend third party tools.
There are some cool ones on the market. Depends on your purpose. Some of them have the ebilty to provide model changes into your model in Service without deploying the whole .pbix file. Using XMLA endpoint.
I used already a lot of times such tools to tweek my model without deploying the whole data model again and again.

Regards

[sergej_og]

Hey @kddavis ,
when data is loaded into PQ look at columns which are now available (after loading new data).
Maybe you will find your new columns. Make them visible for your model.

[kddavis]

I also dont have Power Query options In power bi services and in the desk top because this is import with a sp query I dont have the options of power query.. Should I be connecting differnt with a stored procedure?

[sergej_og]

ok (when I catched it right), when new fields are now available in Desktop you can then deploy this model (with new fields) into Service. Or you can use third party tools bring new fields in - advanced task.

Your semantic model in Service doesn't know anything about your new fields because you deployed it without these fields.

Regards

[kddavis]

Do you recomment a third party?   We dont want to create new semantic models each time we add a new feild to the Store Procedure...  

[sergej_og · Accepted solution]

Of course, I recommend third party tools.
There are some cool ones on the market. Depends on your purpose. Some of them have the ebilty to provide model changes into your model in Service without deploying the whole .pbix file. Using XMLA endpoint.
I used already a lot of times such tools to tweek my model without deploying the whole data model again and again.

Regards

[kddavis]

we need to be able to pull in new field from the source and then publish them to services with out making a new semantice model.. need the old semantice model to reflect the new fields added to the source

[sergej_og · Accepted solution]

This easy one could be helpful for this purpose.
http://alm-toolkit.com/

[kddavis]

Not sure what you mean... I added new fields to my stored procudure and refreshed the semantic model in Power BI services and the new columns are not showing up in Power BI services (-:

[kddavis]

if it does not show up in Power BI services in the data model it will not show up in the desktop