nswilen Tracker

Embedding Report

nswilen — Sun, 14 Oct 2018 05:30:53 GMT

Hello All!

I have successfully embedded my PowerBI report into my blog website using the iframe. However, the embedded version has lost my tabs at the bottom of the report? See the two images below, with the second image being the embedded version. Any suggestions on how to get my tabs for multiple pages back?

Any thoughts are appreciated!

Re: Desktop Query Editor: Custom Column

nswilen — Fri, 09 Mar 2018 13:54:58 GMT

That solved it! Thank you so much, I sincerely appreciate your help!

Desktop Query Editor: Custom Column

nswilen — Fri, 09 Mar 2018 13:13:39 GMT

Hello all,

I'm trying to write a custom column formula in PowerBI desktop Query Editor to do a calculation. I have the following columns:

"Base Weight" = describes the weight of the animal
"Cattle Type" = describes the sex of the animal
"NHTC/All Natural" = describes a status of the animal

If the group of cattle is "NHTC/All Natural" and they are "Steers" (males), I want to take their "Base Weight" + (100*0.1).

If the group of cattle is "NHTC/All Natural" and they are "Heifers" (females), I want to take their "Base Weight" + (100*.09).

Otherwise I wish to leave the new column empty ("null").

When I run this formula the way it is below, it works correctly in that it only selects those groups which are "NHTC/All Natural" but it is taking the "Base Weight" from the "Heifers" and adding it to (100*0.1) instead of (100*0.09).

Any tips on how I can alter this to get "Base Weight" from "Heifers" added to (100*0.09)?

Re: one drive refresh

nswilen — Mon, 11 Dec 2017 11:51:34 GMT

Thank you both! I hadn't located that discussion covering this topic, thank you.

I re-connected to my file via Get Data on Power Bi Service, and my PBIX file is updated from OneDrive as expected. All is well.

Thank you again!

one drive refresh

nswilen — Fri, 08 Dec 2017 12:23:03 GMT

Hello all,

I have found this forum to be an excellent source and thought I'd pose my current issue. I am using a Power BI Pro License.

I have used Power BI Desktop to connect to Azure Blob Storage using Get Data on the ribbon, and I have saved this PBIX desktop file to my OneDrive for Business account. I have published this report to Power BI service, and have set up the refresh schedule to refresh my data daily (my understanding is this data refresh will refresh my data from Azure Blob Storage directly and not refresh visualization changes made in the desktop PBIX file).

My understanding was that since the PBIX desktopfile was saved to OneDrive for Business and published to PBI Service, if I made changes (such as adding a new visualization) and saved the updated file to OneDrive, OneDrive would synchronize those changes with PowerBI Service and my dashboard on the PowerBI Service would reflect the visualization changes within a few hours. I have made changes to my PBIX desktopfile, saved to OneDrive Business, and 8 hours later my PBI Service dashboard still doesn't reflect the update. PBI Service does reflect the visualization changes if I open the desktop file and re-publish with overwrite to PBI Service.

Do I understand the refresh capabilities incorrectly? I appreciate any help. Thank you.

Nate