publish(export) Table to web

[yusif1999]

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]

@yusif1999 , That is possible only in direct query connection

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

[yusif1999]

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)

[v-shex-msft]

Hi @yusif1999,

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