Hi. Is it possible to import calculated data from one pbix file into another file or report/dashboard?
In case you create new formula's and publish the Pbix file user will get new formula after refresh
refer detailed set at :https://www.mssqltips.com/sqlservertip/6155/power-bi-datasets/
@amitchandak thanks for your quick reply!
I might be missing something here.
I have this pbix file, which when I open with PBI desktop, shows me a table with calculated data I am intereseted in.
However, when I upload it to app.powerbi, it shows nothing and returns an error that says "there is no gateway to access the data source".
So when in PBI desktop I use get Data/Power BI datasets, I see the table I need but it is missing the calculated parameters I need.
I've now tried to refresh it manually in app.powerbi twice, and uploaded it to PBI Desktop, but it is still missing the calculated data. Or should I wait for a scheduled refresh in an hour?
Hi @Alex_0201 ,
How the calculated data/parameter looks like in your original pbix file? Could you please provide some screen shots or the related formulas if it has? It is better if you can provide us the pbix file...
It seems its data source is on-premises, then the data gateway is required when publish to Power BI Service. You can review the following documentations for full details about the gateway.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
I probably miss something here. After having used "Power BI dataset", I can see the dataset published online. But when I connect to it, there is a table with missing calculated data. This calculated data, however, can be seen if I open the pbix file.
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates