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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Tables generated in PowerBi not loading in Power Query

Hello,

I have a problem with tables created directly in Power Bi, they don't load in Power Query. I had some preview features on, but I removed them all, restarted Power Bi. Also I refreshed all data multiple times.

I've added printscreens of the table list.

Also something strange, in Power Bi the table icon color is slighly different for those not loading in power query.

Thanks for you help !

Capture4.PNG

 Capture3.PNG

 

 

1 ACCEPTED SOLUTION
Jimmy801
Community Champion
Community Champion

Hello @Anonymous 

 

there is no way to bring your tables, created in Power BI to power query. It works only the other way around. 

What is the requirement? Power Query has a lot mor efficient ways to create your tables. So its best to create them there and to load them afterwards to Power BI

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

3 REPLIES 3
Jimmy801
Community Champion
Community Champion

Hello @Anonymous 

 

there is no way to bring your tables, created in Power BI to power query. It works only the other way around. 

What is the requirement? Power Query has a lot mor efficient ways to create your tables. So its best to create them there and to load them afterwards to Power BI

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Anonymous
Not applicable

Thanks,

 

I used directly PowerBi table in order to use de function autocalendar().

If I'm right i can't use that function in Power Query isn't it ?

And Power Query would have been useful around dates with the ribbon functions...

 

It's a shame it doesn't sync between the two 🙂

Hello @Anonymous 

 

it's not a shame 🙂 ... thats just great. Both languages have really great features. In Power Query is not present a exact same function but a similar one. You can start out to check out the function List.Dates

 

all the best

 

jimmy

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors