Push Dataset - New Table

[wtfstoops]

How does one go about creating a new table within a Push Dataset in Power BI

Dont see any option on Dataset Settings when in log in to powerbi.com -> Dataset Settings

Dont see any guidance on Push Dataset Microsoft documentation - https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets

[v-henryk-mstf]

Hi @wtfstoops ,

Try the specific steps given in the following blog, create Push dataset in PowerBI service, and create a table visual.

link

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[_sfrost]

@wtfstoops 

Convert push dataset to pushstream dataset by enabling Historic Data Analysis

And then a dataset will be created and you will be able to use it further.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

Did I answer your questions? Give a thumbs up and accept this post as solution!

[wtfstoops]

where is that option located?  Looked under dataset's settings - dont see it anywhere

[aj1973]

Open any dashboard in your service and click 

then

and pick your Dataset

[wtfstoops]

how does that address the question of adding a table to an existing push dataset.

I followed the steps above - Seems like its asking me to create an entirely new dataset, with column names etc.  That will a pain for creating one for datset with more than 60 columns.

[aj1973]

@wtfstoops 

Where is your own dataset?

Mine was "Test Live streaming".

[wtfstoops]

Not showing the dataset trying to add a table to.

[aj1973]

What table? You add Datasets there not Tables

[wtfstoops]

So back to my original post/question.  How do you create a table within an exsting push dataset.

Not sure why @_sfrost suggested going down the streaming dataset route.

[Agreenwood]

I see this question still hasn't been answered, and it's not obvious at all how to do it anywhere. Certainly not in the webservice, and even the documentation is a bit hazy.

From my understanding, you can't do this via the webservice, and even if you opened the datset up within Power BI Desktop you still can't do it.

I believe the only way to add more than one table to a push dataset is my implementing the dataset via the API, as documented here:

https://docs.microsoft.com/en-us/rest/api/power-bi/push-datasets

Perhaps someone can confirm this though.