publish(export) Table to web

Anonymous · ‎03-28-2022

Hello everyone,

I have prepared the table by a query that takes data from SharePoint. It works fine, as when I refresh the query the data in the table refreshes automatically. However, I am not sure how to export the table to the web. I do not have a dashboard, just have a table. is it possible to publish the table so that it would be interactive? (as soon as the query is updated, the table is being updated as well).

Thanks in advance!

amitchandak · ‎03-28-2022

@Anonymous , That is possible only in direct query connection

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Anonymous · ‎03-28-2022

Thanks a lot for your assistance. The only point I am not sure, whether it is possible to make dashboard based on 2 different queries(they have identical columns)

Anonymous · ‎04-05-2022

Hi @Anonymous,

You can get data to power bi side and create relationships between two tables based on the same fields. Then you can create visualizations based on two table fields.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Regards,

Xiaoxin Sheng