Forum Discussion

moris's avatar
moris
Regular Visitor
9 years ago

added new columns in datasource

Hi   I'm using PBI.com with SparkSQL + Direct Query. I added new columns in datasource. But the column does not appear on PBI.com. I tried it on PBI desktop and , the added columns was appeared on...
Need Help
kcantor's avatar
kcantor
Community Champion
9 years ago

moris

When you add the new columns in the desktop version, republish the dataset. It should pick up new columns at that time. If you are just refreshing the dataset, it might take a few times to see the changes.

moris's avatar
moris
Regular Visitor
9 years ago

kcantor Thank you for your reply.

 

PBI.com cannot seem to refresh data souce when column added. 

The combination of Spark and Direct Query can use with PBI Desktop, but it can not be published to PBI.com. Because the credentials can not be updated.

Therefore, I have to use PBI.com. But PBI.com can not update the data source.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi moris,

    Do you connect to Spark on Azure HDInsight from Power BI Service? If that is the case, as stated in this article, schema changes are not picked up automatically. After adding new columns, what is the result after you click ”Refresh Now” option in your dataset?

    In addition, do you use same authentication method in Power BI Desktop and Power bi Service when connecting to Spark on Azure HDInsight?

    Thanks,
    Lydia Zhang