Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
wtfstoops
New Member

Push Dataset - New Table

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

 

 

10 REPLIES 10
v-henryk-mstf
Community Support
Community Support

Hi @wtfstoops ,

 

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

v-henryk-mstf_0-1618385648476.png

 

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
Solution Specialist
Solution Specialist

@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!

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

aj1973
Community Champion
Community Champion

Open any dashboard in your service and click 

aj1973_0-1618252244012.png

then

aj1973_1-1618252286948.png

and pick your Dataset

aj1973_2-1618252359905.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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.

streaming dataset.jpg

aj1973
Community Champion
Community Champion

@wtfstoops 

Where is your own dataset?

Mine was "Test Live streaming".

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Not showing the dataset trying to add a table to.

datasets selection.jpg

aj1973
Community Champion
Community Champion

What table? You add Datasets there not Tables

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

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.

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors